Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Add-ins for Outlook (http://www.outlookbanter.com/add-ins-outlook/)
-   -   Mass extraction of email addresses from emails (http://www.outlookbanter.com/add-ins-outlook/63642-mass-extraction-email-addresses-emails.html)

tdstr December 20th 07 05:01 PM

Mass extraction of email addresses from emails
 
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.

Mark McGinty December 23rd 07 07:52 PM

Mass extraction of email addresses from emails
 
"tdstr" wrote in message
...
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



VeloAsia March 7th 08 04:38 PM

Mass extraction of email addresses from emails
 
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...

"tdstr" wrote:

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.



All times are GMT +1. The time now is 11:26 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com