Link to home
Start Free TrialLog in
Avatar of tcalbaz
tcalbazFlag for United States of America

asked on

Exporting a subset of Microsoft Outlook Contacts

Outlook Guru's,
I have thousands of contacts in my Microsoft Outlook 2003 Contact List.  I wish to export just a subset of them based on certain keywords I have embedded in the contacts.  It seems the only choice one has is to export ALL of the contacts.  Isn't there a way to filter out only those contacts you wish to export?

Thank You!

Ted
Avatar of sunray_2003
sunray_2003
Flag of United States of America image

Ted

I would like to search for specific solution what you want but would like to know how difficult it is for you to export the entire contact folder and then get the contacts you need ..

I would think a much complicated method (atleast for me ) is to use some sort of coding like this

How to programmatically import Outlook items from Access
http://support.microsoft.com/default.aspx?scid=kb;EN-US;290658

I would think there could be some control over to what you need to export ..
Avatar of tcalbaz

ASKER

Sunray,

That Microsoft code link you posted is quite interesting in its own way. I like it.

However I need a more specific solution for exporting contacts out of the Outlook Address Book.  

To be more specific I need to export all contacts containing the word "Montana" or any other word I choose to a DOS CSV file.  

Outlook seems to allow you to select all of the contacts you wish to include in a print job by performing a filter search or hand selecting contacts in the Address Book , but I can't understand why it's so hard to do a File export using the same method.

Thank you,

Ted
I am not sure if any inbuilt feature in outlook would help you do the job you want..May be there is a third-party add-in for outlook that can do it for you ..

I see more control using that programe that i directed you to ..
One way, but not the best,  would be to create another contact folder, filter your contacts via your keyword and copy just those to the second contacts folder which could then be exported.  After the export, delete the second folder from your tree.
ASKER CERTIFIED SOLUTION
Avatar of sunray_2003
sunray_2003
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
Avatar of tcalbaz

ASKER

Guru's

What I would love to do is just highlight the contacts that I need and just click export.  

Or

Set a filter for a keyword and just Click Export.

Would anyone have a VBA routine that works from within Outlook that would accomplish this?  

I know (recently) that I can attach/link an Access database to outlook and produce filterable queries but I would hope for a more portable solution that does not require Access.

Ted
Avatar of tcalbaz

ASKER

sunray_2003
I am afraid I must accept your response as the closest solution.
Thank you

Ted