Email Access Report using PDFCreator and Outlook
Posted on 2009-04-11
I want to have a email button on a form, this will automatically email Access report as a PDF using Outlook.
Only way I can think this can be done is to use PDF Printer (I have chosen to use PDFCreator) and save PDF file into the folder. Next step is to email this PDF file using Outlook.
Can you please provide VBA code to do this.
ps. I used SendObject to HTML, this worked fine, but I loose too much of the formatting, also it prints multipages reports into multiple HTML files and what I really need is PDF files I can send to customers.
Access Version 97