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