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.
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.
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.
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?
ASKER
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.
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.
ASKER
wow!
you are a life-saver!!
--D.
you are a life-saver!!
--D.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
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.
itchopin: Your method, unfortunately, does not work with multiple levels of Contacts folders.
Thank you, both.
--D.
driven13,
Cool.
Cool.
ASKER
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.
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.
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.
> 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!