View Single Post
  #2  
Old May 27th 10, 11:55 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP][_4_]
external usenet poster
 
Posts: 552
Default how to save incoming mail in TRUE csv format

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.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54



"Matt" wrote:

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

Ads