General Question

occ's avatar

Is there any software that would be able to extract email addresses and put them into an Excel spreadsheet?

Asked by occ (4176points) February 27th, 2008

My coworker at a magazine saved about 1500 emails from readers regarding a specific feature in the magazine. We’ve turned that feature into a book and would like to send a special email to those readers letting them know about the book. Is there any way to create a list of all those email addresses without manually re-typing all 1500 email addresses? if i have our part-time intern do it I think it might take a whole week.

Observing members: 0 Composing members: 0

4 Answers

Zaku's avatar

Yes, but the software would depend on where/how the email addresses are currently stored.

sferik's avatar

You can grep through the emails using the following regular expression to match email addresses:
m/^[a-zA-Z0–9._%]+@[a-zA-Z0–9.+\.[a-zA-Z]{2,4}/

It would take less than an hour to write and run Perl or Python script that scrubs through the emails to extra email addresses. How are the emails currently stored?

occ's avatar

thanks! The emails are all just saved in his excite.com email. I suppose he could export those? Incidentally, the problem is that all of the emails were forwarded to him by the magazine’s assistant. So all 1500 emails are from the same address. The actual addresses we need are not in the “from:” part of the email, but are in the body of the email when you scroll down and see what was forwarded. I suppose the script coudl just scan for @ signs and do it that way?

sferik's avatar

Yeah, he would need to export them, preferably to plain text files that include the headers.

I’m not familiar with Excite email, but I’d guess that it’s possible. If not, you could always forward the messages to another email account that allows exporting.

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther