Databases and Contacts
 

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

Databases and Contacts
 

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Peter Brown" wrote in message ...
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

Databases and Contacts
 

Peter Brown wrote:

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.
--
Brian Tillman

Databases and Contacts
 

How do you create new categories? The categories I find are business, goals
etc. not product A, B, C etc
"Brian Tillman" wrote in message
...
Peter Brown wrote:

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.
--
Brian Tillman

Databases and Contacts
 

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

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Peter Brown" wrote in message ...
How do you create new categories? The categories I find are business, goals
etc. not product A, B, C etc
"Brian Tillman" wrote in message
...
Peter Brown wrote:

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.
--
Brian Tillman