Send more then one attachment in Email

[mattc66 via AccessMonster.com]

I am using the SendObject to send email attachments out to users.

I would like to send more then one attachment in a single email. What would I
use to do this via VBA?

Current Code:
DoCmd.SendObject acSendQuery, stDocName, acFormatXLS, stEmail
DoCmd.SendObject acSendQuery, stDocName2, acFormatXLS, stEmail

Thanks
Matt

 

[Rick Brandt]

I am using the SendObject to send email attachments out to users.

I would like to send more then one attachment in a single email. What
would I use to do this via VBA?

Current Code:
DoCmd.SendObject acSendQuery, stDocName, acFormatXLS, stEmail
DoCmd.SendObject acSendQuery, stDocName2, acFormatXLS, stEmail

Thanks
Matt

SendObject is limited to one attachment per. If you use automation code against
Outlook or CDO then you can have multiple attachments.