Hello All,

I did my best to find an answer in previous threads, but to no avail.

I'm trying to find a way (or program) to pull mailing addresses that have been sent via email (gmail) and import them into Excel that is more efficient than the whole copy/paste option. There are about 13,000 emails/addresses that need to be imported, , and I think I've developed carpal tunnel after about only 300.

The problem I can foresee is that there are many different formats that the addresses have been submitted, some are in the body of the email in typical address form, (name over address over City/State, etc) others just written in line, and still others just included in their automatic signature.

I am horribly excel-challenged, and despite by best attempts at reaching out to my more experienced friends/coworkers, I remain at a loss, so I figured I'd turn to the true experts.


Any suggestions?

Thank you one and all in advance for your help!!