mulitple attachments with doCmd.SendObject

[janetb]

I currently use the following to send an email with an attached report. Is
it possible to attach 2 reports in the SAME email? Thanks

DoCmd.SendObject acSendReport, "[report 1][report 2]", "Snapshot Format",
strTo, strCC, , strSubject, strMsg, False

 

[Dirk Goldgar]

I currently use the following to send an email with an attached
report. Is it possible to attach 2 reports in the SAME email? Thanks

DoCmd.SendObject acSendReport, "[report 1][report 2]", "Snapshot
Format", strTo, strCC, , strSubject, strMsg, False

It's possible, but not with SendObject. See Tony Toews' Access Email
FAQ page for alternative approaches:

http://www.granite.ab.ca/access/email.htm