Printing a spreadsheet contained within a message

[mike]

Within my company, I have multiple locations that report
daily counts. I set up an Excel spreadsheet that captures
all of this information. The file is set up and saved
using the "Send To -> Mail Recipient" feature so the
locations only have to plug in their numbers and
click "Send this Sheet" so that the message is sent in
it's open status rather than as a document (this is
definitely easier for those who use this).

This works very well for reporting purposes, but when
those receiving the message want to print the message,
Outlook does not seem to recognize the spreadsheet's size
and cuts it off (it is a fairly large spreadsheet running
from left to right. I have the spreadsheet in Excel set
to print nicely on one page.

How can I get this to print on one page from Outlook?

Right now, I have this convoluted process of copying the
sheet into Word and printing it from there. Again, it
prints very well, but can be cumbersome for some and
difficult for others.

Any help would be appreciated.

Thank you,
Mike

 

[Sue Mosher [MVP]]

It might help to understand just what's happening behind the scenes. The Send To | Mail Recipient command creates an HTML format message that converts the Excel rows and columns into an HTML table with fixed width columns. You cannot adjust the column widths in the received message. You would have the same printing problem with any HTML page with fixed column widths that exceed the print width. (Have you thought about switching to landscape mode to print?)

An alternative to copying to Word would be to set Word as the email editor and then forward the message. You can adjust the column widths of the resulting message and then print and discard it.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers