mark sa said:
i need to email out of access not in rich text or snapshot format but
using acrobat is that possible
You can't do it using SendObject, if that's what you were hoping. You
would need to use automation to make this work. There are PDF
print-drivers such as CutePDF, that will let you print a report to a PDF
file. (CutePDF doesn't let you automate the specification of the output
PDF file name/path, as far as I know, but I'll bet there are others that
do.) Having created the PDF file, you could automate Outlook to create
a mail message, add the PDF file as an attachment, and send it. You'd
probably have to use the Redemption library or a utility such as
ClickYes to get past the Outlook security warning about "an application
is trying to send mail on your behalf", if you don't want to have to
reply to that warning every time you send a message this way.