Send more then one attachment in Email

  • Thread starter mattc66 via AccessMonster.com
  • Start date
M

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
 
R

Rick Brandt

mattc66 said:
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
Click to expand...

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