Multiple E-Mail Attachments??

[steph22]

Does anyone know if it's possible to attach multiple tables/query results etc to an e-mail using SendObject? I have 3 reports I need to send to each recipient and would like to be able to send them all in one shot (one e-mail) through Access rather than having to export the files and then manually attach and send with Netscape.

Thanks for any help!
Stephanie

 

[cichlid]

I havent tried this with access but I've used it for similiar purposes, ie sending multiples in one go.
Go to

http://www.winzip.com/other.htm

and download the command line support add in for windows. You'll need a registered version of winzip though.
Add a line in your code after you have created/exported the reports that calls (shell command) the add on to zip up the three reports and then stick the zip file on to your e-mail.
If you need more detailed help gimme a shout.

Seán.
cichlid000@hotmail.com