Sending multiple reports, attachments

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

Guest

Hello. Here's another emailing of reports question.

Can I send multiple attachments?
Do the attachments all need to be from Access, or can I send an Access
report as well as a static document at the same time?
Do all of the attachments need to be in the same format- I'd like to send an
Access report in Excel and attach a word document.

Here's the code I'm working from:
DoCmd.SendObject acSendReport, "Member List", acFormatRTF, Me.EmailName, ,
, "Member List", "Attached is an updated Member List"

I'd like "Member List" to be in Excel, and then attach a word document
called "Handler Questionnaire".

I appreciate your help!
 
Stephanie,

Take a look at the message "Successful Emailing from Access program....",
July 20, 07 in this newsgroup.
 
Back
Top