Solved

Using VBA to extract data from .msg files

Posted on 2013-01-24
3
1,435 Views
Last Modified: 2013-02-04
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.
0
Comment
Question by:iamnamja
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
redmondb earned 500 total points
ID: 38815102
Hi, iamnamja.

This macro seems to be exactly what you want.

Regards,
Brian.
0
 
LVL 76

Expert Comment

by:David Lee
ID: 38817054
Hi, iamnamja.

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

Expert Comment

by:redmondb
ID: 38852958
Thanks,  iamnamja.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question