mulitple attachments with doCmd.SendObject

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Hi, am using "DoCmd.SendObject" in ms access for automated mail purpose with attachment. but i every time will change "to" address and "cc" address. so i request get to and cc address from ms access table field . if possbile pls help
 
Back
Top