Creating a Report PDF, Saving it, and Automatically Emailing it in Access 2007

Microsoft Access 2007

Here is basically what I need:

1. Take Several Reports in Access and Convert to PDF using third party PDFCreator printer
2. Save them in a specific location with a date stamped title
3. Email these PDF's as attachments to several people whose contact info are stored in a table (Done through Outlook)

I'd like to do this all in one step on the push of a button. The secondary goal is to automate this to happen at midnight every night, but the functionality is more important right now. I've found explanations of pieces of this, but nothing that really pulls it all together. I'm not very experienced so manipulating other code is not very easy for me. Any help you can provide would be very appreciated.

ThanksStart Free Trial