How Can I Attach Multiple Reports to an E-mail

[thobholl]

Does anyone know how to append multiple reports to the same e-mail using sendobject?

Is it even possible?

 

[SheepDog]

If you get this answered let me know since I would like to know also.

 

[SpankYou]

Hey,

Is saving them as a word document or a snapshot file, and then adding them as an attachment an option?
If so may be able to help you

Cheers

Sam

 

[CosmoKramer]

I like to use a different way of sending emails, through the use of creating an instance of MS Outlook as an Application object (see Thread705-563408 , my last post).

Using the Add method with the Attachments object you can attach multiple files:

.Attachments.Add (strFileName1) 'add attachment
.Attachments.Add (strFileName2) 'add attachment

etc......



A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
Douglas Adams