带有味精文件的Outlook文件夹,转移到CSV
我有一个来自Outlook的200ish MSG文件的文件夹,我需要将其放入一个CSV中,其中每列代表一个带有相应主题,正文,to的MSG
。
I have a folder with 200ish msg files from Outlook which I need to put in a single CSV where each column represents one msg with corresponding subject, body, to etc.
Any good idea how to do that without doing it manually?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您可以自动化Outlook和Word来完成工作。例如,您可以从Excel或在VBA中自动化前景。在从视觉基本应用程序中自动化Outlook 文章。
Outlook Object模型提供从指定路径或URL打开共享项目的方法。此方法用于打开iCalendar预约(.ICS)文件,VCARD(.VCF)文件和Outlook Message(.msg)文件。该方法返回的对象的类型取决于打开的共享项目的类型。因此,您可以使用该方法从磁盘打开MSG文件,然后读取其属性以填充电子表格。
You can automate Outlook and Word to get the job done. For example, you can automate Outlook from Excel or otherwise in VBA. Read more about that in the Automating Outlook from a Visual Basic Application article.
The Outlook object model provides the NameSpace.OpenSharedItem method which opens a shared item from a specified path or URL. This method is used to open iCalendar appointment (.ics) files, vCard (.vcf) files, and Outlook message (.msg) files. The type of object returned by this method depends on the type of shared item opened. So, you can use that method to open the MSG file from the disk and then read its properties for filling a spreadsheet.