Automatically attach a report as a PDF into my email

[Joe1010]

I’m currently using a function (that is executed with a click of a button) that selects a report and converts it to a .snp format. Then, it creates a new email and attaches the snapshot file without saving the file in a temp table.

However, not all my customers has snapshot viewer installed. So I would like to change it to PDF.

I understand that PDF is the right way, and I’m willing to pay for a better version. However, I would like to have the option to click a button that converts a report to a PDF and attaches it automatically to a new email. I do not want to select file/Print/select the PDF drive then attaché it manually, and then, change back the Printer drive to the regular.

What would be my next step?
Thank you
Joe

 

[Remou]

I understand that Access 2007 has the option to create a PDF file. You may also wish to look at PDFCreator.

 

[Bandenjamin]

Have a look at thread709-1045603

Hope that helps

Dan

 

[TimTDP]

Get a copy of Access 2000 Developer's Handbook, Volume I by Getz, Litwin, and Gilbert. (Sybex)
It is explained in here.
Basically what you need to do is:
1. Install a pdf printer
2. Edit your report so that it is automatically prints to the specific pdf printer
3. Print the report, specifying the file name
4. Edit your report so that it automatically prints to the default printer

Sounds complicated but it is not - I got it right!
All the code comes with the book.
There are 2 volumes available. I suggest that you get them both. With them and tek-tips you have all you need