<div>
Only change I had to make was in the SaveAs line. You'd entered strFil and it should have been strFilename. I also had to change the order of loading the cells, as the header didn't match up with the data. No big deal. Works like a champ. <br />
<br />
Since I was going to open the file in Excel anyway, I changed the FileFormat from CVS to Excel.<br />
<br />
Thank you very much!
</div>


Only change I had to make was in the SaveAs line. You'd entered strFil and it should have been strFilename. I also had to change the order of loading the cells, as the header didn't match up with the data. No big deal. Works like a champ.

Since I was going to open the file in Excel anyway, I changed the FileFormat from CVS to Excel.

Thank you very much!

<div>
<div class="content wysiwyg-content">
I need one-time code that will read &quot;From&quot;, &quot;Subject&quot; and &quot;Date Received&quot; from all messages in a specific folder in a local Outlook mailbox. The folder from which I wish to extract the data is &quot;BAC\Summaries\Success&quot; under the root, which is my email address (if that matters). This is a private OST file, not public folders.<br />
<br />
As I indicated, this will be a one-time run, so I can create a temporary sub and run it through debug. The output desired would be a comma-delimited csv file.
</div>
</div>


I need one-time code that will read "From", "Subject" and "Date Received" from all messages in a specific folder in a local Outlook mailbox. The folder from which I wish to extract the data is "BAC\Summaries\Success" under the root, which is my email address (if that matters). This is a private OST file, not public folders.

As I indicated, this will be a one-time run, so I can create a temporary sub and run it through debug. The output desired would be a comma-delimited csv file.

VBA Code to Read &quot;Header&quot; Info

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

VBA Code to Read &quot;Header&quot; Info

VBA Code to Read "Header" Info