Click here to subscribe
to our weekly newsletter
Exchange Messaging Outlook

EMO back issues



Microsoft Outlook Categories

Any Microsoft Outlook item can be assigned to one or more categories. Consistent use of categories makes it easier to locate specific items. This page sums up a few things I've learned about Outlook categories.

Outlook 2007 does not use the registry for a master category list; they are stored in the default message store (mailbox or pst). If you are setting up a new system and using your old pst the color categories will be available on the new system. You may need to right click on the root folder (Outlook Today), choose Properties and click the button to Upgrade to color categories. This will assign random colors to the categories.

Color categories are removed from Outlook 2007 items sent by email. If you need to include the category, drag the item to the hard drive, zip it and email the zip file. The recipient will drag the item to a folder in their Outlook and if using Outlook 2007, can add the categories to their master list by using the Upgrade to color categories option in the root folder properties.

Unlike with older versions, you cannot paste a comma separated list of categories into the master category dialog and add them all to the Outlook 2007 master list.


 

Master Category List | Keeping Categories Consistent | How To | Category-based Mail Merge | More Fun with Categories | Things You Can't Do with Categories | Tools | More Information

Master Category List

The master category list is not a separate file, but instead is part of the Windows Registry. Each user has a different category list. Outlook 2007 does not store color categories in the registry.

To back up the Master Category List in Outlook 97/98:

  1. Run Regedit and go to HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Outlook and select the Categories key.
  2. Choose Registry | Export Registry File to make a copy of the Categories branch of the registry.

To back up the Master Category List in Outlook 2000:

  1. Run Regedit and go to HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Outlook and select the Categories key.
  2. Choose Registry | Export Registry File to make a copy of the Categories branch of the registry.

To back up the Master Category List in Outlook 2002:

  1. Run Regedit and go to HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Outlook and select the Categories key.
  2. Choose Registry | Export Registry File to make a copy of the Categories branch of the registry. Note that this list is in Unicode encoding and is not compatible with earlier versions of Outlook.

To back up the Master Category List in Outlook 2003:

  1. Run Regedit and go to HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook and select the Categories key.
  2. Choose Registry | Export Registry File to make a copy of the Categories branch of the registry. Note that this list is in Unicode encoding and is not compatible with versions other than Outlook 2002.

To use any of these methods to move categories to another computer using a compatible version of Outlook, you'll need to change the version number in the key before importing.

You can use this exported branch to distribute a category list to other Outlook users. See the MSKB article How to Migrate Custom Categories to Other Users. CAUTION: Using a .reg file to propagate a category list does not update a user's own list; instead it completely replaces it. I personally do not recommend this method, because it eliminates much the utility of the Category feature for users. See the next section for what I think is a better method.

If you remove a category from the master list, any items marked with that category are not affected. In the Categories dialog box, that category is listed as "(not in master list)."

Also see:

  • OL2000 Custom Categories Are Not Transferred from Outlook 2000 to Outlook 2002
  • Back to Top

    Keeping Categories Consistent

    I'm convinced that many people worry too much about keeping the Master Category List consistent from user to user, when what they really want is to keep the categorization of the items themselves consistent. It is critical to remember that the category set on an individual item is totally independent of the user's Master Category List.

    For example, you can set a category of Blue on an item, then delete Blue from your personal Master Category List. The item is still categorized as Blue. In the Categories dialog, you should now see its category as "Blue (not on master list)." Anyone who has never had Blue on the master list will see the same thing.

    Yes, it would be nice if Microsoft had made this easier, but the real issue usually is making category assignment consistent. In a public folder, consider handling that with a custom form that forces users to pick from an "official" list of categories. I've put together a sample form at Required Categories Contact Form.

    Another approach would be to use code behind the form to make category assignment automatic based on the value of other fields in the form. 

    One situation where the Master Categories list makes a difference is when you are working with a large folder and dragging a large number of items between categories. When a category is not in the Master List, you risk losing the original categories from items added to new categories. You can avoid problems by dragging fewer items at a time or select the items, right click and choose Categories.

    Back to Top

    How To ...

    To filter a folder on multiple categories ... 

    On the More Choices tab in the Filter dialog, type the names of the categories separated by "AND" Do not use the Categories button. 

    For example, to display contacts who are in both the Personal category and  the Business category, type in "Personal AND Business."

    In Outlook 2007, use the Advanced tab to create the filter. Use Categories for the Field, select contains as the Condition and enter the category names, separated by AND in the Value field.

    The QueryBuilder can be used to create the AND filter if you use Outlook 2002, 2003 or 2007. See Using QueryBuilder for more information.

    Also see:

  • Using a SQL Filter on the Task List
  • Sorting Contacts by the Categories Field
  • Remove Categories From Messages

    Rules wizard doesn't have an option to remove categories from messages you send or receive, it can only add more categories. You'll need to use VBA to remove categories.

    Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
            Item.Categories = ""
    End Sub

    Visit OutlookCode for assistance with Outlook programming.

    Back to Top

    Category-based Mail Merge

    You can't use categories directly as selection criteria for a Word mail merge in Outlook 97 and Outlook 98. (It is added in Outlook 2000 -- but works only if each item has only one category assigned to it.) That does not mean that it can't be done, though. It just takes a bit of extra effort. Here are several methods:

    Method #1:

    Select Contacts by category using a filter, copy all matching items to a new Contacts folder, add that folder to the Outlook Address Book, and use it as the mail merge source. See the MSKB article Q160521: Categories Unavailable to Mail Merge in Word. Also see Helen Feddema's Code Sample 48 for a VBScript routine to do the copying to another folder for you.

    Method #2:

    You can use Excel to drive a bulk mailing based on a category. See the Microsoft article Using Microsoft Excel To Do a Bulk Mailing in Microsoft Outlook.

    Some of the third-party mail merge tools also support merging by category.

    Back to Top

    More Fun with Categories

    See Microsoft Exchange and Outlook Distribution Lists for details on how to use categories to create instant Personal Distribution Lists.

    You can use categories in Rules Wizard rules, both as part of conditions and as actions, assigning one or more categories to an item. For example, I have an autoresponder to handle subscription requests for my Exchange Messaging Outlook newsletter. I mark the incoming requests with a category of "Response sent."

    If you create a new Outlook item from another item, the categories carry over. Back to the autoresponder example: I manage the mailing list in a Contacts folder that uses a custom form. New items are created by dragging the incoming message to the folder. When the new recipient is created, it has the category of "Response sent." This also works with replies and forwards; as long as you send in RTF format, the recipient will see any category you apply. However, if you send a message with a category via the Microsoft Network service, it may remain in the Outbox unsent. See the MSKB article Q163176: MSN Mail Not Sent with Category or Contact Attachment.

    Helen Feddema's Code Sample 55 demonstrates how to use an Outlook form to display all contacts by category. It's up to you to take the next step of writing code to do something with all those contacts. 

    Also see: 

  • To filter a view by more than one category
  • To troubleshoot Rules Wizard rules with categories
  • Back to Top

    Things You Can't Do with Categories

    You can't create a view that shows both categories and subcategories. In other words, the Categories field can be used for grouping just once. What you might try is a set of categories that themselves include a subcategory: Friends - Good, Friends - Very Close, etc. 

    You can't search and replace a category directly without writing code. (I have a code example of how to search and replace a category in my book, Teach Yourself Microsoft Outlook 2000 Programming in 24 Hours.) However, you can select a bunch of categories, then right-click, choose Categories from the pop-up menu and work with the Categories for the entire group of items.

    Back to Top

    Tools

    Aladdins CategorieZ   Select an Outlook item and instantly see the categories assigned. To make changes just use the checkboxes next to the category. Sort your categories into meaningful Groups. Restrict which folders a category is displayed in. Want to filter the current view by category, easy, select the category (or categories) and click the Filter button...Done. Share your categories across your organization.
    Category Manager   Category Manager allows sharing of color categories; it adds a sidebar to the folder view as well as opened items, in which you can group your categories and assign them lightning fast; and it adds a reminder, which optionally prompts you if you forget to assign a category. There's a lot more, please click the link for the complete list of features.
    Category Organizer   Category Organizer adds a sidebar to Outlook allowing instant access to your categories. Select a contact and instantly see the categories assigned, need to make changes, easy just use the checkboxes. Set filters to show only the items in specific categories.
    CodeTwo CatMan   CodeTwo CatMan allows sharing of Outlook categories with other users on the local network. Centralized management using a shared configuration file. Version 3.0.1
    Back to Top

    More Information

  • To set up subcategories
  • Categories vs. multiple Contacts folders
  • OL2000: How to Migrate Custom Categories to Other Users (MSKB)
  • How to use Windows Scripting Host to read the master categories of a user (CDOLive)
  • Outlook Custom Categories Form -- Uses a hidden CDO message to hold the categories for a folder; very handy technique for any type of folder-specific list. (CDOLive)
  • Backing Up Master Categories (Outlook Tips website)
  • This page is printer friendly
    Updated Apr 30 2008

    Copyright Slipstick Systems. All rights reserved.
    Send comments using our Feedback page

    Home | What's New | Exchange Server | Outlook | Utilities | Bookstore
    About Slipstick | Feedback | Privacy Policy | Site Map | Archived Pages | Link to Us | Advertise