Sending multiple reports, attachments

[Stephanie]

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!

 

[Dale Fye]

Stephanie,

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