MS Outlook Query to Export filtered contacts

Posted on 2011-10-10
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.

Question by:jeffbarbacpa
    LVL 26

    Expert Comment

    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

    Author Comment

    Outlook 2010
    LVL 26

    Accepted Solution

    To get the category list:

    In Outlook 2010, you have to access the location

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


    Author Closing Comment

    ok solution, but didn't quite work for what I had

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
    Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now