Email first report in HTML and second in Excell

  • Thread starter Thread starter StephanieH
  • Start date Start date
S

StephanieH

I'm currently using the following code to send a Summary report in HTML
format in the body of an email. Is it possible to amend the code to send a
detail report in Excel format below the first report?

DoCmd.SendObject acSendReport, "rpt_Summary Internal Assigns by Balance",
acFormatHTML, "Tom Davis", , , _
"Placement Summary " & MyMonth, ""
 
I'm currently using the following code to send a Summary report in HTML
format in the body of an email.  Is it possible to amend the code to send a
detail report in Excel format below the first report?  

 DoCmd.SendObject acSendReport, "rpt_Summary Internal Assigns by Balance",
acFormatHTML, "Tom Davis", , , _
    "Placement Summary " & MyMonth, ""
Click to expand...

No. SendObject is severely limited in that respect. If you want to
add the second part, you need to use some other method. usually
automating your e-mail client either directly or through something
like CDOSys.
 
Back
Top