Sending report as HTML

[Stephen]

I have a report that is successfully created from MS Access 2002. I have a
macro that quickly opens an email template and attaches the report as an
HTML document. However, if the report is longer than one page, the system
breaks the HTML attachment into as many separate files.

Hence, if the report is 2 pages long, it breaks the HTML attachment into two
separate HTML attachments.

Is there a way to set up the system so that no matter how many pages the
report is, it sends only a single HTML file?

Macro is as follows:

Function macSendEmailQuote()
On Error GoTo macSendEmailQuote_Err

DoCmd.SendObject acReport, "RptQuoteSheet", "HTML(*.html)", "", "", "",
"Requested Quote From Company", "", True, ""


macSendEmailQuote_Exit:
Exit Function

macSendEmailQuote_Err:
MsgBox Error$
Resume macSendEmailQuote_Exit

End Function

-Stephen

 

[Steve Schapel]

Stephen,

Sorry, I think there is no option with this. If the object you are
sending is a form or datasheet, it goes into one html file, but not so
with reports.

By the way, just as a matter of interest, what you are using is not a
macro.

- Steve Schapel, Microsoft Access MVP