From exceldata to Outlookmessage

[Manoj]

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
..

 

[Ken Slovak - [MVP - Outlook]]

You can create an Outlook MailItem or PostItem, read your text file
using something like Windows Scripting using the FileSystemObject to
get the file as a string and then set Item.Body equal to your string.

A more sophisticated method would be to open the Excel worksheet using
automation code and read the cell contents into strings and put those
in .Body. That way you'd be working with live data and not a saved
file.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm