I am trying to draw data from various places in an open workbook to
compile a mail message. I am limited by my mail server in how far
across the message I can go before the server wraps the text around to
the next line. When it does, my column headers appear on 2 rows making
it unreadable.

I have 9 columns that a

Name Office 8/01 8/02 8/03 8/04 8/05 8/06 8/07

Under the date column headers will be hours to be worked on that date.


All the data is generated from other sheets, and I compile it all on a
sheet called MAIL MESSAGE. Onec all the data is complied, is looks
great and is all lined up (in Excel). When I copy it, then paste it
into Outlook, it appears Outlook inserts several TABS in between
columns so that the coumns do NOT line up correctly.

I desperately need to insert this data into a plain text Outlook mail
message with as little space between columns as possible.

Is there anyway to put this data into a mail message in plain text
mode?

I hope I explained it well enough for you to understand.

Please help!


--
JohnGuts
------------------------------------------------------------------------
JohnGuts's Profile: http://www.excelforum.com/member.php...o&userid=30174
View this thread: http://www.excelforum.com/showthread...hreadid=566457