automation of PDF's for reports

[7h33y3]

I have Office 2007 and downloaded the pdf plugin for it. What I would
like to do is setup an automated Access report function that would
programatticaly create a .pdf from a filtered report using the name on
the report as the file name, and then email the file to the person
using his email addess in the database.

I can find NOTHING about this anywhere and I'm not even sure where to
start.

Anyone got any advice?

 

[Geno]

Hi,
You can try using Stephan Lebans module on ReportToPdf on his website
www.lebans.com I have it working great with Office 2003. What it does is
take your report, converts it to pdf and then attachs it to your email. You
will have to make some adjustments to the code to make it work for you.
Good luck
Geno