将Outlook邮件正文隐藏到Excel列 [英] Covert Outlook Email Body to Excel Columns

问题描述

我有数千封电子邮件，其中包含来自在线销售的订单确认。我已将电子邮件导出为CSV，但电子邮件正文包含在一个单元格中。电子邮件的正文包含我想要使用的主要内容。



我的目标是将正文内容转换为每种类型数据的列。有订单号，交易日期/时间，送货地址，账单地址，电子邮件和订单明细，包括订单项和定价。



我很满意每个客户的姓名，电子邮件，地址和电话号码。奖金是将其他数据与订单详细信息联系起来。



我已经在Excel中尝试了文本列，但我没有明确的换行符能够利用。我是这类数据的新手。



实际的身体内容看起来结构合理。有人可以帮助我使用VBA或Excel提示来实现我的目标吗？我希望我正确地发布这个，这里是布局的一个例子。所有电子邮件都具有相同的布局/格式，但地址线因原产国而异。



在下面的示例中，格式看起来不错，除了购买详情似乎已被包装。



提前致谢！

I have several thousand emails with order confirmations from online sales. I have exported the emails to a CSV, but the body of the email is contained within one cell. The body of the email contains the primary content that I want to utilize.

My goal is to convert the body content into columns for each type of data. There is a Order Number, Transaction Date/Time, Shipping Address, Billing Address, Email and order detail with line items and pricing.

I'd be happy with the name, email, address and phone number of each client. A bonus would be to have the other data with order details.

I've tried the text to column in Excel, but there are no clear line breaks that I'm able to utilize. I'm a novice with this type of data.

The actual body content seems pretty well structured. Could someone help me with VBA or Excel tips to accomplish my goal? I hope I'm posting this correctly, here is a sample of the layout. All the emails have the same layout/format, but the address lines vary depending on the country of origin.

In the sample below, the format looks good, except the purchase details appear to be wrapped.

Thanks in advance!

"The following order was placed with Merchant:

Order Number : 5
Placed       : 03/19/2014 20:37:09 CDT

Ship To:                                 Bill To:
FIRSTNAME LASTNAME                       FIRSTNAME LASTNAME
[e-mail]                         [e-mail]
5559991111                               5559991111
                                         
                                         
123 Address                              123 Address
City ST 55555                            Portland OR 97210
US                                       US

Code           Name                                    Quantity     Price/Ea.         Total
-------------------------------------------------------------------------------------------
V-BotAAS2      Item Name                                      1        $29.95        $29.95
                                                                                      
                                                            Shipping: Price+:         $6.95
                                                                   Sales Tax:         $0.00
-------------------------------------------------------------------------------------------
                                                                       Total:        $36.90
"

推荐答案

29.95

29.95

运费：价格+：

29.95 Shipping: Price+:

6.95
销售税：

6.95 Sales Tax:

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