[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MS Outlook Query to Export filtered contacts

Posted on 2011-10-10
4
Medium Priority
?
710 Views
Last Modified: 2012-05-12
Hi all, so I have an outlook contacts folder where each contact is assigned one or more "Categories."

I am trying to write a macro in MS Outlook to take the contacts folder, and for each different category export it to a different CSV file.  So for instance the categories are Mike, Jeff, and Tracy.  I want to take all the contacts with a category of Mike and export it to Mike.csv.  Take all the contacts with a category of Jeff and export it to Jeff.csv, etc.

Can anyone point me in the right direction.  I have alot of experience writing code in Excel and Access, but not so much in Outlook.

Thanks,
Jeff
0
Comment
Question by:jeffbarbacpa
  • 2
  • 2
4 Comments
 
LVL 26

Expert Comment

by:e_aravind
ID: 36946750
which version of Outlook is involved in this process?
I remember "Master Category List" being used in the older verison of Outlook clients to store the category data
0
 

Author Comment

by:jeffbarbacpa
ID: 36948293
Outlook 2010
0
 
LVL 26

Accepted Solution

by:
e_aravind earned 750 total points
ID: 36948397
To get the category list:

In Outlook 2010, you have to access the location
C:\Users\XXXXXX\AppData\Local\Microsoft\Outlook\RoamCache

The file name starts with Stream_CategoryList xxxx.dat. This is an XML file



0
 

Author Closing Comment

by:jeffbarbacpa
ID: 37134256
ok solution, but didn't quite work for what I had
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today as you open your Outlook, you witness an error message: “Outlook is using an old copy of your Outlook Data File…”. Probably, Outlook is accessing an old OST file.
I came across an unsolved Outlook issue and here is my solution.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question