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
SendObject 3
report in a loop 4
200KB versus 35MB 0
multiple attachments 3
Passing an argument from a query to a command 0
email forms and reports 1
Option Not to send email 6

Top