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

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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>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
>
>

Peter Brown <(E-Mail Removed)> 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

How do you create new categories? The categories I find are business, goals
etc. not product A, B, C etc
"Brian Tillman" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Peter Brown <(E-Mail Removed)> 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

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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> How do you create new categories? The categories I find are business, goals
> etc. not product A, B, C etc
> "Brian Tillman" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Peter Brown <(E-Mail Removed)> 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
>
>