Email first report in HTML and second in Excell

[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, ""

 

[pietlinden]

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, ""

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.

 

[StephanieH]

I figured as much, but I thought I'd ask.

Thanks for answering!