0

My firewall sends me a notifcation to my email every time a policy is violated.

I have about 2500 emails in .msg format that I want to put into one excel document.

Basically I am looking for a way to automate processing each .msg file and putting it on a new line in an excel document.

All 2500+ .msg files are in a single folder.

I understand that .msg files hold binary data, and thats ok. I can clean up the excel document once it is created.

Thanks, Aaron

Esteban Küber
  • 35,226
  • 13
  • 82
  • 97

2 Answers2

0

Take a look at Outlook MSG file format specification.

You should consider getting the messages in some other format that is easier to parse.

Paweł Polewicz
  • 3,591
  • 2
  • 19
  • 23
0

Redemption or the Aspose libs can help you out here. There is also Sean Curries script.

76mel
  • 3,963
  • 2
  • 21
  • 21