Using Outlook object to send e-mails

[MDJ52]

I am current using the Outlook object as part of a Access module.
I create a report based on information in some tables. I then output that report and use Attachments.Add to add the document to the e-mail.

Attachments.Add("c:\my documents\text.doc&quot

Based on the table I loop through a series of code that creates up to 400 e-mails per day. We now have a survey we wish to send with these reports. Is there a way to add more than 1 attachment?
Thanks for any help.

 

[vbajock]

Just add it again using the add method.
Use Attachments(index), where index is the index number, to return a each Attachment object.