Sending multiple reports, attachments

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!
 
G

Guest

Stephanie,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error emailing Excel attachment 2
multiple attachments 3
send reports by mail 1
mulitple attachments with doCmd.SendObject 2
Send Email Attachment 1
Email Report as Attachment with Voting Buttons 2
select and e-mail multiple attachments via Outlook 13
DoCmd.SendObject acSendReport 1

Top