Send 2 access reports in the same mail

monplankton

Registered User.
Local time
Today, 20:25
Joined
Sep 14, 2011
Messages
83
I wander if anyone can help I'm wanting to send 2 reports to the same address but when you use the docmd. option you can only select one report at a time or is there a way round it?

I'm using 2003

Thanks
 
Thanks for the link Paul. I've read through it and understand what it is doing but if the attachment is within access i.e. a report what would the path be?
 
To use automation and attach multiple items, you'll need to export the reports and then attach them. I don't think there's a method like SendObject that let's you attach multiple items.
 
No problem. I typically use OutputTo or TransferSpreadsheet to create the files, then attach. You can delete them after sending the email if desired.
 

Users who are viewing this thread

Back
Top Bottom