I'm using Outlook2003 to find contacts which belong to one or both of two
categories but NOT to a third category. I can't get it to return the correct
results. What's the syntax I should be using on each line of the Advanced
Find dialogue box?

I've tried this:

(Line 1) Categories contains "ABC1" or
(Line 2) Categories contains "ABC2" and
(Line 3) Categories does not contain "ABC3"

but (I think) it just gives me everyone that doesn't have ABC3 as their
category and ignores the other two criteria. I've tried combining these
criteria with/without a search criterion specified in the 'More Choices' tab
for Categories to no avail. I've tried leaving the quotes out or in. You can
see I don't really know what I'm doing, here... ;-) I'm sure I had
something similar working ok, way back in the mists of time, but I'm blowed
if I can recreate it now, when I need it...

I know I could just move copies of all Contacts to a separate temporary
Contacts subfolder and then sort them out by category grouping to end up with
just the ones I want, but it's bugging me I can't make the 'Find' facility
work as it presumably should.

Also, why is the 'More Advanced...' button always greyed out - does that
only come into play when you've added lots and lots of lines and there's no
more room? Or does it require some missing plug-in that I've failed to
activate?

Thanks in advance!

You can't AND the same field together unless you do it within 1 line.

Try the Querybuilder -
http://www.outlook-tips.net/archives/2004/20040927.htm

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"browniebodrum" wrote in message
...
I'm using Outlook2003 to find contacts which belong to one or both of two
categories but NOT to a third category. I can't get it to return the
correct
results. What's the syntax I should be using on each line of the Advanced
Find dialogue box?

I've tried this:

(Line 1) Categories contains "ABC1" or
(Line 2) Categories contains "ABC2" and
(Line 3) Categories does not contain "ABC3"

but (I think) it just gives me everyone that doesn't have ABC3 as their
category and ignores the other two criteria. I've tried combining these
criteria with/without a search criterion specified in the 'More Choices'
tab
for Categories to no avail. I've tried leaving the quotes out or in. You
can
see I don't really know what I'm doing, here... ;-) I'm sure I had
something similar working ok, way back in the mists of time, but I'm
blowed
if I can recreate it now, when I need it...

I know I could just move copies of all Contacts to a separate temporary
Contacts subfolder and then sort them out by category grouping to end up
with
just the ones I want, but it's bugging me I can't make the 'Find' facility
work as it presumably should.

Also, why is the 'More Advanced...' button always greyed out - does that
only come into play when you've added lots and lots of lines and there's
no
more room? Or does it require some missing plug-in that I've failed to
activate?

Thanks in advance!

Thanks - I'm nervous about doing anything that involves the registry, so
before I do take that step, can you just confirm whether it's possible to do
this query on one line WITHOUT using Query Builder:

'Categories' contains A and contains B but does not contain C

and how does it need to look/be composed in Advanced Find?

Having read the KB file, I know I can do this:

'Categories' contains A and contains B

but I'm not sure whether I can do the second part, i.e. it's possible, but
not working because but I'm just not getting the syntax right.

Thanks again.

I don't think you can do the NOT - I'll have to test it. But the
querybuilder is nothing to be nervous about - messing it up won't cause
outlook not to load.

Categories Contains A OR B, NOT C
Doesn't work - I have one that is in both B and C and its included. If its
written as
Categories contains A or B
Categories does not contain C
They are all OR'd together.

it works perfectly in querybuilder -
AND (all must be true)
- Categories contains A or B
- Categories doesn't contain C


--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"browniebodrum" wrote in message
news
Thanks - I'm nervous about doing anything that involves the registry, so
before I do take that step, can you just confirm whether it's possible to
do
this query on one line WITHOUT using Query Builder:

'Categories' contains A and contains B but does not contain C

and how does it need to look/be composed in Advanced Find?

Having read the KB file, I know I can do this:

'Categories' contains A and contains B

but I'm not sure whether I can do the second part, i.e. it's possible,
but
not working because but I'm just not getting the syntax right.

Thanks again.

Sorry it's taken me so long to leave feedback, but I've now installed Query
Builder and it's helped me a great deal, it does just what I needed, so
thanks for the tip.

browniebodrum

Diane,
I went to the link you suggested in order to get the Query Builder to work,
but I do not know how to add the QueryBuilder key to the registry. What does
that mean? How is that done? Also, in outlook I can pull down the Query
Builder but it is grayed out. How can I make the Query Builder
active/enabled? I have Outlook 2007 on Windows XP.


"Diane Poremsky [MVP]" wrote:

I don't think you can do the NOT - I'll have to test it. But the
querybuilder is nothing to be nervous about - messing it up won't cause
outlook not to load.

Categories Contains A OR B, NOT C
Doesn't work - I have one that is in both B and C and its included. If its
written as
Categories contains A or B
Categories does not contain C
They are all OR'd together.

it works perfectly in querybuilder -
AND (all must be true)
- Categories contains A or B
- Categories doesn't contain C


--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"browniebodrum" wrote in message
news
Thanks - I'm nervous about doing anything that involves the registry, so
before I do take that step, can you just confirm whether it's possible to
do
this query on one line WITHOUT using Query Builder:

'Categories' contains A and contains B but does not contain C

and how does it need to look/be composed in Advanced Find?

Having read the KB file, I know I can do this:

'Categories' contains A and contains B

but I'm not sure whether I can do the second part, i.e. it's possible,
but
not working because but I'm just not getting the syntax right.

Thanks again.