Link to home
Start Free TrialLog in
Avatar of driven13
driven13

asked on

Extracting Email Addresses from the Outlook Contacts Folder and Contacts sub-directories

Hello all:

The Question Title pretty much says it all.

I am running Outlook 2002 on Windows XP Pro and I need to extract all the email addresses from the Contacts folder and all its subdirectories (there are a few I'm afraid).

Is there an easy way of doing this?

Thank you very much for any help.

--D.
Avatar of David Lee
David Lee
Flag of United States of America image

Hi driven13,
> I need to extract all the email addresses from the Contacts folder and
> all its subdirectories

And do what with them?  Write them to a file, display them onscreen?  

Cheers!
Avatar of driven13
driven13

ASKER

Hello BlueDevilFan:

I would like to extract them to an excel docement if I could.  I am trying to create a whitelist for myself.

Thank you,

--D.
How about a TSV file?  Would that be good?  And do you only want the email address and nothing else?  Also, what about entries with multiple email addresses?  How would you like to handle them?
A TSV should be fine.

I just require the email addresses, and that's it.

I need the multiple email addresses too but they are a few and far between.

My main concern for this whole process is that it needs to be able to extract the email addresses from the Contacts subfolders too and there are a bunch of them, sometimes 4 levels deep.

Thank you for your time.

-D.
The depth of the nested folders isn't a problem.  I just wrote a macro that will delete an Outlook folder and all subfolders, so I can use it as the basis for this.  I'll have this posted shortly.
wow!

you are a life-saver!!

--D.
ASKER CERTIFIED SOLUTION
Avatar of David Lee
David Lee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
How  about using export?

File > Import and Export...> Choose "Export to a file..." and Next > Choose "Microsoft Excel and Next > Choose "Contacts" folder and Next > give the address book a name and Next > Next and then Finish

BlueDevilFan:  I will try it out and let you know ASAP.  You are the best!

itchopin:  Your method, unfortunately, does not work with multiple levels of Contacts folders.

Thank you, both.

--D.
driven13,

Cool.  
BlueDevilFan:

It worked beautifully!!!

Thank you very much for your expertise and for your time.

I have two small questions for you:

1)  Can I use this same macro to get email addresses from other folders inside Outlook?

2)  Will this macro work with Outlook 2003 if I wanted to extract the email addresses from the Contacts folder and sub-folders?

Again, appreciate it.

--D.
driven13,

You're welcome.  I'm glad to have been able to help out.  In answer to your questions:

1.  Yes, so long as the folders involved are contact folders.
2.  It should.  I'd say give it a try and if you run into a problem post a message here and I'll fix whatever didn't work right.