帮助将内容从Outlook 2010电子邮件导出到Excel电子表格 [英] Help with exporting Content From Outlook 2010 Emails To Excel Spreadsheet

问题描述

我正在尝试将电子邮件中的数据导出到Excel电子表格中以节省时间。我知道这是可能的，但我无法编码以挽救我的生命。有人可以帮我这个吗？

我的电子邮件是从在线表单生成的，并且通过以下格式的表格来生成：

个人详情
Title	先生
FirstName	名称
LastName	名称
性别	男性
工作经验	4 - 5年
联系方式
电子邮件	电子邮件
电话	电话号码
城市/城镇/州	地点
居住国	国家
国籍	国家
查询详情
查询来源	营销类型
查询	问题
DPA - 请勿再次与我联系	是
我需要提取信息，但这是手动执行此操作的时间点，所以我希望有人可以帮我写代码为我这样做？ 谢谢！

解决方案

这已被涵盖这里有一些深度。你会看到线程旁边的链接。这个过程总结在
从电子邮件消息中提取数据到Excel ，工作基本上已经为您完成了
从电子邮件中提取数据到Excel，访问或Word表格加载项

I am trying to export data from my emails, into an excel spreadsheet to save myself time. I know it's possible, but I can't code to save my life. Could someone please help me with this?

My emails are generated from an online form, and coem through as a table in the format of:

Personal details
Title	Mr.
FirstName	Name
LastName	Name
Gender	Male
Work experience	4 - 5 years
Contact details
Email	Email
Phone	Phone Number
City/town/state	Place
Country of residence	Country
Nationality	Country
Enquiry details
Source of enquiry	Marketing Type
enquiry	Question
DPA - do not contact me again	Yes
I need to extract the information, but it is such a time sink to do this manually so I'm hoping that someone can help me write a code to do this for me? Thanks!

解决方案

This has been covered here in some depth. You will see the links alongside the thread. The process is summarised at Extract data from e-mailed messages to Excel and the work has essentially been done for you at Extract data from e-mailed messages to Excel, Access or a Word table add-in

这篇关于帮助将内容从Outlook 2010电子邮件导出到Excel电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！