A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Add-ins for Outlook
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Mass extraction of email addresses from emails



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old December 20th 07, 05:01 PM posted to microsoft.public.outlook.program_addins
tdstr
external usenet poster
 
Posts: 2
Default 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.
  #2  
Old December 23rd 07, 07:52 PM posted to microsoft.public.outlook.program_addins
Mark McGinty
external usenet poster
 
Posts: 25
Default 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


  #3  
Old March 7th 08, 04:38 PM posted to microsoft.public.outlook.program_addins
VeloAsia
external usenet poster
 
Posts: 1
Default 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.

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
System crash requires manual extraction of emails and addfress boo Jack Outlook Express 3 May 30th 07 08:55 AM
What's the best way to send mass emails? Jim Moberg Outlook - General Queries 6 December 18th 06 07:07 PM
Send mass emails using outlook Joseph Outlook - Using Contacts 5 August 27th 06 11:52 AM
How to make Outlook to remember the Email addresses of answered emails? Juan I. Cahis Outlook - General Queries 5 August 3rd 06 03:58 PM
Automating retrieving email addresses from 306 received emails? StargateFanFromWork Outlook - General Queries 6 January 10th 06 11:04 PM


All times are GMT +1. The time now is 05:13 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-2025 Outlook Banter.
The comments are property of their posters.