从Outlook的多个文件夹导入电子邮件数据 [英] Import Email Data from outlook from multiple folders

问题描述

我所工作的公司正在尝试收集有关其员工收到的电子邮件数量以及这些电子邮件来自何处的更多信息。

The company that I work for is trying to gather more information on how many emails are received by it's employees and where those emails are coming from.

基本上我想要做的就是从电子邮件来自的人那里获取一张表格，以及发送日期。我注意到了一些方法：

Basically what I want to be able to do is grab a table out of outlook with a who the email is from, and the date it was sent. I have noticed a few ways to do this:

-Excel：手动将电子邮件复制到电子表格中将您在Outlook中设置的列复制到电子表格中，简单且只需要excel和outlook（基本办公套餐），但你一次只能复制100封电子邮件。即使您选择
以上，该副本也不起作用。

-Excel: manually copy emails into a spreadsheet copies the columns you have set as your view in outlook onto a spreadsheet, easy and only requires excel and outlook (basic office package) but you can only copy maybe 100 emails at a time. Even if you select more, the copy doesn't work.

第三方插件/ exe：坚固而简单，我发现了一对，目前为止最好的是"Outlook Stat View"。它允许您报告每个发件人收到的电子邮件数量，但仅限于固定期限。你不能只是转发
电子邮件详情。   https://www.nirsoft.net/utils/outlook_statistics.html

-3rd party plug-in/exe: rugged and simple, I've found a couple, best one so far is "Outlook Stat View". It allows you to do a report for how many email you've got per sender, but only for a fixed period. You cant just do a dump of email details.  https://www.nirsoft.net/utils/outlook_statistics.html

- 访问：您可以导入电子邮件详细信息，但一次只能执行一个邮件文件夹。即使您选择了父"收件箱"也是如此。文件夹它只会导入该文件夹中的电子邮件，而不是子文件夹，这是一个大问题，因为大多数
员工将电子邮件分类到子文件夹中。因此，您必须通过并手动将每个文件夹添加到导入。

-access: you can import email details, but you can only do one mail folder at a time. Even if you select the parent "inbox" folder it will only import the emails in that folder, not the subfolders, which is a big deal because most employees sort emails into subfolders. So you would have to go through and manually add each folder to the import.

- 开发内部脚本/ VBA：我们有一些开发人员，他们可能会编译转储，但想看看我们是否可以获得更便宜的现成解决方案。

-develop internal script/VBA: we have some developers around, who could probably code a dump, but wanted to see if we can get a readymade solution that would be cheaper.

基本上我的问题是，如果您可以使用get external设置访问来自我的收件箱的所有电子邮件，包括子文件夹访问中Outlook工具的数据。目前我一次只能从一个文件夹导入，即如果我
选择收件箱文件夹，它不会从子文件夹中获取电子邮件。

我每天都在苦苦挣扎，苦苦挣扎

Everyday I'm Struggling, Struggling

推荐答案

>基本上我的问题是，您是否可以使用访问中Outlook工具的获取外部数据来设置从我的收件箱中获取所有电子邮件的权限，包括子文件夹。目前我一次只能从一个文件夹导入，即如果我选择收件箱
文件夹，则不会从子文件夹中抓取电子邮件。

>Basically my question is if you can set access to grab all the emails from my inbox, including subfolders, using the get external data from outlook tool in access. At the moment I can only import from one folder at a time, i.e. if I select the inbox folder it doesn't grab emails form sub folders.

不，这是按设计。要将电子邮件导入Microsoft Access包括子文件夹，如果只有几个子文件夹，则可以将这些步骤作为收件箱文件夹重复。

No, this is by designed. To import the emails to Microsoft Access include the sub folders you can repeat the steps as the inbox folder if there is only a few sub folders.

如果子文件夹是两个，那么你可以考虑写一个VBA代码枚举文件夹并导出消息。

And if the sub folders is two much, you may consider write a VBA code enumerate the folders and export the messages.

问候& Fei

Regards & Fei

这篇关于从Outlook的多个文件夹导入电子邮件数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！