View Single Post
  #1  
Old May 27th 10, 11:03 PM posted to microsoft.public.outlook.program_vba
Matt
external usenet poster
 
Posts: 119
Default how to save incoming mail in TRUE csv format

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