Solved Extract info from emails into excel spreadsheet?

Dell Inspiron b120 notebook
August 24, 2012 at 13:59:47
Specs: Windows 7, 2.2 GHz
I want to embark on a decent project...

I get paypal payments and their accompanying emails. Is there a way to extract the name, address, product, price paid and etc type of info from the emails and populate them into an excel file?

Kind of like creating a database of sorts? What are the ways to explore doing something like this?

See More: Extract info from emails into excel spreadsheet?

Report •

August 26, 2012 at 06:36:34
✔ Best Answer
If all of the emails are formatted exactly the same, or fairly close, they could be dumped into a text file, imported into Excel then have a macro run against the data to get it into a format that fits your needs.

I used to get email responses for seminar registrations that I would process in that manner.

It wasn't perfect, and it usuallybtook some manual clean up, but it was better than copy/paste cell by cell.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question