<div>
Hi, iamnamja.<br />
<br />
If the macro @redmondb linked to doesn't work out for you, then I can help.
</div>


Hi, iamnamja.

If the macro @redmondb linked to doesn't work out for you, then I can help.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Due to constraints on our outlook server, we had to archive many of our past emails into a network folder in a .msg format. &nbsp;<br />
<br />
I was wondering if there is a way to run through these .msg files in a folder and extract a set of data. &nbsp;For example, the sender/reciever info, date recieved, categories assigned...<br />
<br />
Please let me know! &nbsp;Thank you.
</div>
</div>


Hi,

Due to constraints on our outlook server, we had to archive many of our past emails into a network folder in a .msg format.  

I was wondering if there is a way to run through these .msg files in a folder and extract a set of data.  For example, the sender/reciever info, date recieved, categories assigned...

Please let me know!  Thank you.

Using VBA to extract data from .msg files

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

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.

Outlook

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.