Email two reports

S

Scott

I have a requirement to send two reports that attaches
automaticly to the same email. I have tried the code
below, but only Rpt_1 attaches to the email. How do I do
this?

stDocName = "Rpt_1"
stDocName2 = "Rpt_2"
DoCmd.RunCommand acCmdRefreshPage
DoCmd.SendObject acSendReport, "stDocName",
acFormatRTF, , , , "SAMD R&R Monthly Report", , True
DoCmd.SendObject acSendReport, stDocName2,
acFormatRTF, , , , "SAMD R&R Monthly Report", , True
 

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

Email two reports 0
report in a loop 4
SendObject Attachment file name 1
SendObject 3
Print Report Background colours 2
email blank report 1
200KB versus 35MB 0
Emailing a report in Access 0

Top