HTML output with multiple pages

[J Miller]

I am using the DoCmd.OutputTo command and outputting a report to an HTML
file. If my report is multiple pages I am getting a seperate HTML file for
each page. Is there any way to combine all the pages into one HTML file?

Many thanks.


Jeff

 

[Jim Brown]

I researched this before (and now doing it again) without getting a solution.
If you find something please pass it on.

If you can get by without the nice formating of the report, you can use
TransferText to HTML. It will produce a basic HTML Table, with column
headings from your table or query.

Use this in VBA or I believe the Macro's can do this to.
DoCmd.TransferText acExportHTML, , "StatusEmails_Temp",
"c:\Temp\Status.html", True