自动将数据从Outlook .msg文件收集到excel字段 [英] Automate collection of data from outlook .msg files to excel field

问题描述

每次违反策略时，防火墙都会向我发送一封电子邮件通知.

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

我有大约2500封.msg格式的电子邮件，我希望将它们放入一个excel文档中.

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

基本上，我正在寻找一种自动处理每个.msg文件并将其放在excel文档中的新行上的方法.

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

所有2500多个.msg文件都位于一个文件夹中.

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

我知道.msg文件包含二进制数据，没关系.创建Excel文档后，我就可以对其进行清理.

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

谢谢， 亚伦

推荐答案

赎回或Aspose库可以在这里为您提供帮助.还有 Sean Curries脚本.

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

这篇关于自动将数据从Outlook .msg文件收集到excel字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！