mulitple attachments with doCmd.SendObject

J

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
 
D

Dirk Goldgar

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

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
 
Top