Mass extraction of email addresses from emails

T

tdstr

Outlook 2003

I'm curious if anyone knows of a addin that will allow extraction of
email addresses from individual emails and export them into a Excel
spreadsheet.
 
M

Mark McGinty

tdstr said:
Outlook 2003

I'm curious if anyone knows of a addin that will allow extraction of email
addresses from individual emails and export them into a Excel spreadsheet.

You don't really need an AddIn to do this, it can be accomplished by script.
I wrote a script to export entire messages (including sender's email) to SQL
Server. This particular scrpt isn't interested in the recipients of any
messages, but it wouldn't take much to enumerate the recipients collection
and add them to the output.

Excel supports .CSV files, which is just plain text data, columns separated
by commas, each row on its own line.

If you wanted a unique list of emails that would take a little more work,
I'd probably add them all to a dictionary, using the email address as the
key, and then dump the dictionary contents to file at the end.


-Mark
 
V

VeloAsia

DS Development has an app called Email Address Collector which is one of the
best I've tried. Mark, good to hear about your script, but it's all Greek to
me...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top