HTML output with multiple pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J Miller - 19 Mar 2007 23:13 GMT

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

Reply to this Message

Jim Brown - 31 Mar 2007 23:52 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> Jeff

Reply to this Message