Tks for you reply.

In excel it is easy to find out how it works but in
outlook there is no macro recording and so no idea about
how it works

rgds
manoj
-----Original Message-----
Manoj,

Generally a straight copy paste will work for displayed
data. To automate
this you will need to instance outlook and use the
outlook paste method. The
resultant data will be an editable table withn outlook

Steve
"Manoj" wrote in message
...
Hi,

This is just to clear a doubt. It is possible to save
the
contents in the excel sheet as a text file.

But is it possible to save excel file as outlook
message.

That is save from excel sheet to outlook mail Draft
folder. I have created macro for making text file and
from
text iam taking manually to outlook and adding some more
on that. If i can directly take that to outlook draft
then
it is more easy to amend and adjust.

tks & rgds
Manoj


.