Excel Worksheet publish to HTML - can you control the scaling of the HTML to mirror Excel?

Hello,

I have the following code, most of which comes from Ron de Bruin and his excellent site involving much about emailing in Excel VBA.

The code simply generates an email in Outlook from a sheet of data. It works great except for one thing. The scaling of the published HTML is different than the scaling of how the sheet appears in Excel. This causes columns of data to wrap in the published HTML whereas the data in the Excel spreadsheet does not wrap. Ideally, I would like for the published HTML to look exactly as the sheet looks in Excel. I tried to use 'ActiveWindow.Zoom = 60' in the Function below to scale the Excel sheet prior to publishing but it has no effect at all.

Any help is appreciated.

TV

Please Login or Register  to view this content.

It seems partly due to a very wide sheet of data, 26 columns wide and even though the formatting appears correct in Excel, when converting to HTML and pasting into Outlook it seems to reformat column widths so as to fit on the max width available within Outlook.

Even so, I would be curious to know how to overcome this and also how to scale down what gets pasted into Outlook.

TV