how to save incoming mail in TRUE csv format

M

Matt

I have a script in Outlook 2007 that automatically saves incoming emails to a
folder as a txt. Simply changing my code to olCSV does not comma separate the
values. How can i convert this to a csv format? Is it possible?

Obviously I'm a real newbie. Thanks in Advance or all/any help!

here's my code:

Sub saveemail(myItem As Outlook.MailItem)
myItem.SaveAs "c:\mail\" & myItem.Subject & ".txt", olTXT

End Sub

Matt
 
S

Sue Mosher [MVP]

Outlook has no native ability to turn text into a csv file. If you want to do
more than save the message as a .txt file, you'll have to add your own code
to parse the message content or parse the .txt file. Either way, only you
know what you have in mind. It's not clear at all from your description what
"values" you want saved in .csv format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top