Mass extraction of email addresses from emails

  • Thread starter Thread starter tdstr
  • Start date Start date
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.
 
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.
Click to expand...

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
 
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...
 
Back
Top