Macro VBA Email Access report as PDF

[haffy311]

Hello,

Can anyone recommend a previous post/thread to help me get started creating the code for the following scenario:

-Email a specific 'report' from an Access Database to multiple users as a PDF file


Thanks,
Haffy311

 

[apr pillai]

Hello,

Can anyone recommend a previous post/thread to help me get started creating the code for the following scenario:

-Email a specific 'report' from an Access Database to multiple users as a PDF file


Thanks,
Haffy311

Take a look at this link for a discussion on sending Automated e-mail Alerts.

You can use the DoCmd.SendObject method as shown below to convert your Report into PDF format and send as attachment to e-mail message:

DoCmd.SendObject acSendReport,"myreport","PDFFormat(*.pdf)","To e-mail addresses","cc",,"Subject Text","Message Text",false