List of email addresses from all email messages in outlook - how to

T

TechGeek

Linked in, facebook, and a few other online services allow you to uploa
a comma delimited listing of email addresses to see if there are folk
registered on the service who you know

I would like a program or add-in or utility search my outlook 2007 ps
file and make a list of every email address it finds

These would not be from my contacts, or not just from contacts, bu
from the headers and body of my received and sent emails

I would think this would be a popular utility

Any idea if something like that exists, preferably free

By the way I did look at the lists of programs available here and di
not see one that fits the bill
Thanks
 
T

techstress

vba should be able to fit your needs.

an outside loop iterating through all folders,

an inside loop iterating through all messages,

for each message, save addresses from to, from, cc, bcc, & body
fields.
 
D

Diane Poremsky [MVP]

I'm not aware of any utility specifically for this, but there are some that
can go through the messages and make new contacts using the From address.
Once in contacts its easily to make an address-only list by creating a
custom view that has only the email address field.

While there are valid reasons for making such a list, I don't think
importing it to facebook or linkedin is appropriate. You should only use
addresses worthy of a contact there since it sends out solicitations to
those addresses.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Poll: What version of Outlook do you use?
http://forums.slipstick.com/showthread.php?t=27072
 
T

TechGeek

I really don't want contacts created, just a list.

With facebook, there is an option for finding people who's email
addresses you have, without sending out invitations. Not certain about
linked-in but I believe that is also the case.

Anyone with a little VB skill want to create such a utility? I'm sure
it would be well received!

'Diane Poremsky [MVP said:
;110778']I'm not aware of any utility specifically for this, but there
are some that
can go through the messages and make new contacts using the From
address.
Once in contacts its easily to make an address-only list by creating a
custom view that has only the email address field.

While there are valid reasons for making such a list, I don't think
importing it to facebook or linkedin is appropriate. You should only
use
addresses worthy of a contact there since it sends out solicitations
to
those addresses.
 
D

Diane Poremsky [MVP]

If you only want the To and From address, you can do it fairly easy with
VBA. Parsing the bodies to collect addresses is more effort. Once collected,
you should remove duplicate addresses - fairly easy in Excel.

See
http://www.devnewsgroups.net/office...-need-grab-smtp-address-not-contact-name.aspx
for code samples to get you started.

If you need help writing vba, the vba experts hang out in the program_vba
group
http://www.microsoft.com/communitie....aspx?dg=microsoft.public.outlook.program_vba

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Poll: What version of Outlook do you use?
http://forums.slipstick.com/showthread.php?t=27072


TechGeek said:
I really don't want contacts created, just a list.

With facebook, there is an option for finding people who's email
addresses you have, without sending out invitations. Not certain about
linked-in but I believe that is also the case.

Anyone with a little VB skill want to create such a utility? I'm sure
it would be well received!

'Diane Poremsky [MVP said:
;110778']I'm not aware of any utility specifically for this, but there
are some that
can go through the messages and make new contacts using the From
address.
Once in contacts its easily to make an address-only list by creating a
custom view that has only the email address field.

While there are valid reasons for making such a list, I don't think
importing it to facebook or linkedin is appropriate. You should only
use
addresses worthy of a contact there since it sends out solicitations
to
those addresses.
 
T

TechGeek

Do you think there is a way to get in touch with someone who coul
create a simple routine that would just look in the folder headers, no
the body? Sound fairly straightforward
 

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