Reports - Export as HTML

Nathan Barley

New Member
Joined
Jul 15, 2004
Messages
9
Hi,
I send out daily emails based on various reports that Access produces from the database I made. Originally, I exported the report to PDF using PDF Factory, and sent that out as an attachment to the email. This preserved all formating, background colors and spacing exactly as the printed version.

My boss though, ever one to save 2 seconds by not clicking on something, wants to see the report directly in the email, as he used to with my copy/paste Excel reports I used to send him.

In trying the direct to email export option, things are formatted poorly, and all the colors are stripped. Similarly, with HTML export.

Is there ANY way I can preserve background colors (e.g: from conditional formats) when exporting to HTML, etc? Or am I destined to exporting to HTML, then going into Dreamweaver and readding the color? :(
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Forum statistics

Threads
1,221,842
Messages
6,162,333
Members
451,760
Latest member
samue Thon Ajaladin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top