Modify Custom View SQL Filter Tab

  • Thread starter Thread starter ctc
  • Start date Start date
C

ctc

I am trying to create a custom view which filters my Outlook 2007 contacts by
specific categories.

I would like my custom view to show all contacts which include a category of
Attorney, but exclude all contacts which include the categories of MIA, or
KIA, or Client, or Craig's Friends, or Craig's Relatives.

To do this I have used the Advanced tab to enter the above criteria into the
views filter:

("urn:schemas-microsoft-com:office:office#Keywords" LIKE '%Attorney%' OR
"urn:schemas-microsoft-com:office:office#Keywords" <> 'MIA' OR
"urn:schemas-microsoft-com:office:office#Keywords" <> 'KIA' OR
"urn:schemas-microsoft-com:office:office#Keywords" <> 'Client' OR
"urn:schemas-microsoft-com:office:office#Keywords" <> 'Craig''s Friends' OR
"urn:schemas-microsoft-com:office:office#Keywords" <> 'Craig''s Relatives')

This filter returns all contacts which do not include Attorney as a
category, which does not produce the desired results.

How can I use the SQL tab to customize my filter to obtain the desired
results?
 
Use the AND operator instead of OR. However, if one contact is assigned to
both 'Attorney' and 'MIA', the filter will return it.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
<http://www.vboffice.net/product.html?lang=en>


Am Fri, 2 Apr 2010 09:49:02 -0700 schrieb ctc:
 
Back
Top