SendObject: Is attaching > 1 object possible?

[Philippe]

Hi: I'd like to e-mail more than one report within the same automated message I'm creating under MACRO. Unfortunately the SendObject action will not allow me to include more than one report in its "Object Name" Arguments section. I've tried typing the additional report in and separating it from the first with commas, "&", ";", but nothing seems to work. Suggestions anybody? Thanks...

 

[accesswatch]

Try this link they do a PDF and Mail Class library for Access which may meet your needs.
Quote from there site:

"The e-mail class supports auto log on (no profile choosing) and easy inclusion of any number of attachments (Now there's something you cant do with Access' SendObject method!"

details at
http://ourworld.compuserve.com/homepages/attac-cg/

The site is worth visiting as they do a number of handy free files and some free code

Hope this helps
Trevor from www.accesswatch.co.uk