Print to one sheet.

[Marcster]

Hello People,

I have a sheet in Excel with the page area set to:
A1:I117
so when printed it prints onto one sheet.
OK so far.
But this sheet gets e-mailed in the body of an e-mail message.
When the recicpient opens the message and prints,
it doesn't fit onto a single page.

How to fix this so the whole of the message gets printed
onto one page?. (Shrink to fit).

Using Outlook 2000.

Thanks,

Marc.

[XLGibbs]

I am not sure if you will be able to control the page setup properties on the recipients end of things....since you would have to have the macro fire on their Outlook, not the sent message.

I thought you were emailing the sheet as an attachment, not within the body. Certainly, if you are able to succeed in removing all the code and attaching the file as per your posts in the excel forum...the page area of the attachment would remain valid on the recipients end.

That being said, i don't think you can format the page setup of the recipients email.. I could be wrong though...

[Marcster]

Hi Gibbs,
This question regards a different workbook.

I can have access to the users Outlook to insert VBA code
or modify there print set up if need be.

But think this question regarding shrink fit to one page thing in Outlook
doesn't exist.

Oh well,

Marcster.