Databases and Contacts

[Peter Brown]

I have just learned how to construct a database in excel so that I can sort
my customers by the products that they buy (using filters). What would be
useful is to do this with my contacts in Outlook 2000 so that I can ask
"which customers by product "A" and just those contacts would appear - is
this possible?

Peter

 

[Sue Mosher [MVP-Outlook]]

You can do something similar in Outlook. Perhaps the easiest way is to set a category on each item corresponding to each product. That way, you can track multiple products for each contact in the By Category view or in a filtered view.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Brian Tillman]

I have just learned how to construct a database in excel so that I
can sort my customers by the products that they buy (using filters).
What would be useful is to do this with my contacts in Outlook 2000
so that I can ask "which customers by product "A" and just those
contacts would appear - is this possible?

Assign a category of "Product A" to those contacts who purchase that product
and then group by category.

 

[Peter Brown]

How do you create new categories? The categories I find are business, goals
etc. not product A, B, C etc

 

[Sue Mosher [MVP-Outlook]]

Just type in whatever text you want to use for the category.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers