Emailing a PDF

[Gkirkup]

I often output reports as a PDF. I also use SendObject to send emails from my application. But is there a way to send a PDF as an attachment with SendObject? Perhaps not, as the PDF would not be within my application?

Robert

 

[burrina]

Example:

DoCmd.SendObject acSendReport, [name of report], acFormatPDF, "recipient@company.com",[cc email(s)],[bcc email(s)], [Message Subject], [MessageBody], True

HTH

 

[Gkirkup]

That's very helpful. Is there any way to send this without using SendObject? I have had many crashes after sending emails with SendObject. The email is sent, and then Access freezes.

Robert

 

[burrina]

I don't have any idea why Access is crashing, i suspect it's nothing to do with email.
I don't use Outlook myself but there are many code examples on the site and Google if you do a search.

Also examples in the Sample Database section.