VBA帮助：Outlook到Excel [英] VBA Help: Outlook to Excel

问题描述

我不喜欢我对VBAs或编码一无所知，所以我正在寻求一些帮助。我正在尝试将数据从电子邮件
的正文传输到Excel中，以便我可以更好地分析数据。内容的格式如下（以下），我想将我用蓝色突出显示的信息提取到Excel文件中的单独列中。非常感谢您的帮助。 

以下父项已删除来自COMPANY（R）的一个或多个学生帐户。

某人姓名
（ id_parent：0000 ）

退出调查：

------------

1。您为什么决定终止此COMPANY学生帐户？

  我现在太忙了： 

2。您在使用COMPANY时遇到任何困难吗？

   No：

     Technical可靠性:(选择一项）：
响应

    客户支持:(选择一个）：  response

    评估:(选择一项）：  ; 回复

    教程:(选择一个）：  response

    报告:(选择一项）：  ; 回复

    说明:(选择一项）：  回复

3。根据您对COMPANY的经验，您会向朋友或家人推荐COMPANY吗？对于学校？

   是： 

4。你会再次使用COMPANY吗？在什么情况下？

   是的，明年： 

5。您对公司的改进有什么建议吗？

- BEGIN -

--- END ---

6。 COMPANY Corporation是否允许您在部分或全部调查回复中引用您的营销和广告？请注意，COMPANY可能会编辑您的语法和理解的调查回复，
但不会更改内容或上下文。

否

详情：

--------

姓名：某人姓名  （id_parent：0000）

Login_name：  [e-mail] （SOMEONEUSERNAME）

Account_type ：
family

Deleted_account：
SNAME [学生姓名]（id_student：0000）

From_host：000.00.000.00

Cookie.COMPANY_com：

Cookie.magic_COMPANY_com：

Cookie.referer_COMPANY_com： 

Cookie.referer_first_COMPANY_com：

With_browser：Mozilla / 5.0（iPhone; CPU iPhone OS 10_3_2与Mac OS一样X）AppleWebKit / 603.2.1（KHTML，类似Gecko）版本/ 10.0 Mobile / 14F5065b Safari / 602.1

With_plugin： 

On_server： 

On_node：

日期：2017年4月12日 - 16:37:34

[此电子邮件由COMPANY（R）系统自动生成。]

==========

解决方案

我之前已在此论坛中深入介绍了这一点，并在 http：/ /www.gmayor.com/extract_data_from_email.htm

从该页面末尾链接的是一个为您完成工作的流程。

I don't know anything about VBAs or coding so I'm looking for a bit of assistance. I am trying to transfer data from the body of an email into Excel so that I can better analyze the data. The content comes in the format (below), and I'd like to extract the information I've highlighted in blue into seperate columns in an Excel file. Your help is greatly appreciated. 

The following parent has deleted one or more student accounts from COMPANY(R).

SOMEONE NAME (id_parent: 0000)

EXIT SURVEY:

------------

1. Why did you decide to terminate this COMPANY student account?

  I am too busy at this time: 

2. Did you have any difficulties using COMPANY?

  No:

    Technical reliability: (Choose one): response

    Customer support: (Choose one): response

    Assessment: (Choose one): response

    Tutorial: (Choose one): response

    Report: (Choose one): response

    Explanations: (Choose one): response

3. Based on your experience of COMPANY, would you recommend COMPANY to a friend or family member? For a school?

  Yes: 

4. Would you use COMPANY again? Under what circumstances?

  Yes, next year: 

5. Do you have any suggestions for improvement of COMPANY?

--BEGIN--

---END---

6. Does COMPANY Corporation have your permission to quote you on part or all of your survey responses for use in marketing and advertising? Please note that COMPANY may edit your survey responses for grammar and comprehension, but will not change the content or context.

No

DETAILS:

--------

Name: SOMEONE NAME  (id_parent: 0000)

Login_name: [e-mail] (SOMEONEUSERNAME)

Account_type: family

Deleted_account: SNAME [STUDENT NAME] (id_student: 0000)

From_host: 000.00.000.00

Cookie.COMPANY_com:

Cookie.magic_COMPANY_com:

Cookie.referer_COMPANY_com: 

Cookie.referer_first_COMPANY_com:

With_browser: Mozilla/5.0 (iPhone; CPU iPhone OS 10_3_2 like Mac OS X) AppleWebKit/603.2.1 (KHTML, like Gecko) Version/10.0 Mobile/14F5065b Safari/602.1

With_plugin: 

On_server: 

On_node:

Date: 12-Apr-2017 - 16:37:34

[This e-mail was automatically generated by the COMPANY(R) system.]

==========

解决方案

I have covered this in some depth in this forum previously and have summarised the methodology at http://www.gmayor.com/extract_data_from_email.htm

Linked from the end of that page is a process that will do the job for you.

这篇关于VBA帮助：Outlook到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！