Mail Merge with Attachment (1 Viewer)

Hello,

I'm wondering if it's possible to set up an automatic Outlook mail merge with attachments from Access. We have several account managers, and each one receives a different version of the same report - filtered to his/her accounts. For now, I have set it up for the user to select the account managers and hit "Print Reports" to save each individual report into a destination folder. The user then uses an email template, attaches the report, and sends the email to an account manager. She has to send this email separately to each account manager.
Is there a way to do this in one automatic step?

Thanks,
Jeff

See if this gets you started:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

Thank you pbaldy, I will give that a try!

No problem!