|
- Subject: RE: how to save incoming mail in TRUE csv format
- Author: Sue Mosher [MVP]
- Date: 27 May 2010
- References: 1
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.
"Matt" wrote:
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
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
> 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
| 27 May 2010 | how to save incoming mail in TRUE csv format | .Matt |
| 27 May 2010 |  RE: how to save incoming mail in TRUE csv format | .Sue Mosher [MVP] |
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)
All times are in (US) Eastern Daylight Time (GMT -4:00)