Importing Contacts That Have Multiple Categories from Access
Making imported contacts appear properly under all their categories is as easy as using the correct delimiter in the database.
March 26, 2006
After importing contacts from an Access database, I need to view them in the By Category view. If a contact has multiple categories blue, auto, and radio, for example Outlook displays that contact under one category titled blue, auto, radio instead of displaying three separate categories. How can I fix this?
In your Access database, change the data in the field that holds the category information so that it uses a semicolon as the delimiter rather than a comma. After you import the data, the three categories separated by semicolons in the Access database will appear in Outlook as three separate category groups, and a contact that has three categories will appear in each of those three category groups.
About the Author
You May Also Like