Advanced Boolean Search for Contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Travis - 22 Dec 2003 01:16 GMT

I thought I would challenge you MVP's since this got no takers last month:

> Hi there -- I'm trying to find all contacts whose Notes have string
> "AAA" but not "BBB". The two ways I've tried thus far are
> unsuccessful:
>
> 1) Advanced Find - Notes CONTAINS "AAA"
> Notes DOESN'T CONTAIN "BBB"
>
> 2) Advanced Find - Notes CONTAINS "(AAA) AND NOT (BBB)"
>
> I think it might be easy to do with the Contact View Filter by SQL but
> I can't quite get the syntax. Any other suggestions for making this
> happen? Thanks in advance!
>
> pt

Reply to this Message

Sue Mosher [MVP] - 26 Dec 2003 22:57 GMT

Try:

("urn:schemas:httpmail:textdescription" LIKE '%AAA%' AND
"urn:schemas:httpmail:textdescription" LIKE '%BBB%')

Signature

Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> I thought I would challenge you MVP's since this got no takers last month:
>
[quoted text clipped - 12 lines]
> >
> > pt

Reply to this Message