Report Sent as HTML Body - multiple pages

[chris.williams]

Hi All:



I have a report that is send to an HTML file and then the HTML file is specified as the HTMLbody of an outbound message.

The problem I am having is that if the report spans multiple pages, the first page is set as the HTML body, but any subsequent pages are not. As I look into the actual HTML file that is created by the report, there is one file for each page.

How do I tell a report to save to a one-page HTML file rather than splitting it up into multiple pages?

DoCmd.OutputTo acOutputReport, varReportName, acFormatHTML, varApprovalRequest

Set objOutlook = CreateObject("Outlook.application")

Set objEmail = objOutlook.CreateItemFromTemplate(varEmailTemplate)
With objEmail
.To = varSendTo
.cc = varSendCC
.Subject = varSubjectText
.HTMLBody = varHTMLBody
.Attachments.Add varApprovalRequest
.Display
.SentOnBehalfOfName = varSendFrom
End With

[June7]

Don't know if you can.

Why send as body of email?

Could output to PDF and attach the PDF.

[chris.williams]

Thanks June7 - I temporarily resolved the issue by changing the size of the page to 14" rather than 11". But I will encounter the same problem if there is more text in the fields. Probably a custom page size is what is needed - just haven't done that yet.

As to why, it's all about presentation. The fewer clicks a user has to issue, the better refined the product it is. There are appropriate places for attachments, this one going to executives is not one of them. They won't take the time to open an attachment and a fixed width/courier fonts look just out of place for a communication which requires formatting. Additionally, with an HTML body, I can insert command buttons that take the user to web sites that are next in line for the workflow - While something similar can be done with PDF, it's arguably not as elegant.

[June7]

Okay. I think if the report is going to have variable length you will have problems. Good luck and sorry I have nothing else to offer.