Raymond Kim
Raymond Kim

Reputation: 1

export selected fields from a body of an email to .csv file

I have a shopify website that has a Request a Catalog page where users post there information and I receive it in email Outlook 2010 in this format in the body:

Is there a way I could export those fields from multiple submissions into one master.csv file so I dont have to constantly copy and paste the information indiviually?

Upvotes: 0

Views: 361

Answers (1)

Trent
Trent

Reputation: 4306

I'd suggest taking a look at the free Microsoft Add-In Power Query (from Excel 2010) for extracting mails from your Exchange account directly into Excel.

You will have to define your queries in order to get the data you want; however, what you are asking for seems quite basic and achievable with limited knowledge of Power Query.

Have a look at the Introduction to Microsoft Power Query for Excel page.

Upvotes: 0

Related Questions