Email report in PDF Format using a Macro

[lreecher]

Using a macro I can generate and export files in pdf format. Then I have to
create an email, attach the report and send. Is there a way to email a report
in pdf format directly from Access utilizing a macro?

 

[CCross]

I don't have an answer for you but a question. I am trying to do what you
have accomplised but don't know how.
Thanks

 

[lreecher]

Once the report is built, open it in design view.
Select File - Page Setup.
Select the page tab.
Click on 'Use Specific Printer' then the 'Printer' button to the right.
In the 'Name' field select Adobe PDF from the drop down menu, then select
'Properties' to the right.
Check the Add Document Information and Delete log files for successful jobs.
My preference is to leave the other boxes unchecked.
From the Adobe PDF Output Folder drop down menu select 'My Documents\*.pdf.
This will put the pdf formatted report in the folder.
Save and close out of the report.
Create a macro with the Action: Open Report.
Run the macro and the report will be sent to My Documents in pdf format.

Please let me know if you need additional information.