Access 2007 use VBA to Send Report as a PDF attachment to Outlook without Security Msgs
Posted on 2009-05-07
I need to email out a bunch of statements to different recipients
I started using DoCmd.SendObject acSendReport, rptName, acFormatPDF, Recipient etc
But I get the security messages from Outlook that I don't want the user to see.
So I am now trying a different approach
I am OK using VBA code to send an email with an attachment using something like
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
.To = Recipient
.subject = subject
.Body = message
But I can't quite work out how to get the report as a PDF to attach to the email
This may be the simple part but just can't see it
A bit of code would be lovely!