Exporting multiple access reports to e-mail

[Mrogersy]

I am trying to export 5 reports (.xls format) from Access to a new e-mail message in outlook. I am struggling on the code (VB) to add multiple files to one e-mail. Does anybody know if this can be done, if so, do you have some sample code that may be of assitance?

Mrogersy

 

[PHV]

Have a look at the Add method of the Outlook.MailItem.Attachments object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Mrogersy]

Is the add method in the MS Access VB code, or in MS Outlook VB code?

 

[PHV]

In the code that instantiate the MailItem object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886