Export to PDF and Email multiple PDF's per email

[greyoxide]

The tool that we use for web analytics only has one export option availible, CSV. Since our sales reps cannot distribute the CSV file to their clients they need individual PDF's which they can distribute. In order to save myself an entire day of data entry every month, I am building an access application which will import the CSV and spit out one report for each advertiser.



This is where my problem is. I would like to auto email the report to the rep as a function of the report generation process. I have connected Access to Outlook in the past but this was for a one report that went to a few addresses. In this case I would need the opposite, to export to pdf and send all of "Jim's" reports to him in a single email.

any help is greatly appriciated.

[pbaldy]

To send multiple attachments, automation would be one option:

http://support.microsoft.com/?kbid=161088

CDO might be another, though I haven't tested multiple attachments.