Hello,

I have written a report that I need to email someone everyday. I would like send it as html but it is producing as two pages. How do I make it one page in the html format when I export/email? The report is built from two existing reports; one embeded in the other. I'm not very technical with Access so simple is better. Thanks!

Outputting a report to HTML is best suited for for publishing the report to to a web site, not to email. This is probably why it is in multiple pages. I use it for this purpose with great success.

I would recommend attach the report as a Access Snapshot file or a PDF.

If you must have it as HTML, then the only way I now to do this is to write a lot of VBA code to create the report manually to generate the HTML.

I have not actually tried it, but you might look into exporting your report to Word:

http://office.microsoft.com/en-us/access/ha010448891033.aspx

Then write code to save the word document that you created with the export into a html document.

It at least sounds like it might work.

The reason I'm sending as an HTML in an email is so the recepient can quickly view the report. It takes much longer to open excel or word. I think the bigger issue is that it continues to go to 2 pages regardless of the format. I can figure out how to force it to one page. Something about the embeded report I think.