copy paste from Excel to outlook as text

[rina]

Hi,

How to copy from MS Excel 2003 data and paste as plain unformatted text to
Outlook 2003 Email?

The Outlook 2003 paste special is dimmed out.
Now it's pasted as Excel object or something, which one can't edit properly
and recipients may have problems too ...

Actually I never needed to paste Excel as Excel object to Email, while I
have been a frequent user of both . Therefore it's has left an obscure
option for me.

John

 

[Barbara Wiseman]

Hi John,
I find when I copy from excel (using control C) and paste into Outlook
(using control V), and both are 2003 versions, I get a table as in word. I
do have the outlook option to use word to edit & compose mail.
I have recorded a little macro in word to convert a table to text and put it
on a button. You could highlight the table and right click to get the same
option.
Hope that helps a bit,
Barbara