Send 2 access reports in the same mail

[monplankton]

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

 

[pbaldy]

If you're using Outlook automation is one option. The basics here:

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

 

[monplankton]

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?

 

[pbaldy]

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.

 

[monplankton]

Thanks Paul, thats what I thought.

 

[pbaldy]

No problem. I typically use OutputTo or TransferSpreadsheet to create the files, then attach. You can delete them after sending the email if desired.

 

[monplankton]

Do you have some code that does all this as an example?