Publish - Page Setup

I am publishing via the following VBA code:

Please Login or Register  to view this content.

However, when I do this the HTML page is across 4 printer pages. I want to auto send this to a fax as well as saving it (from the HTML file, not the excel document. Fax will only read HTML pages.)

Anyone got any hints on how I can achieve this ?

Many thanks for any help!
Jon.

Jon_Sarge

Welcome to Exceltip forum

Please take a couple of minutes and read the Forum Rules then wrap your VBA code (Rule 3)