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-comfficeffice#Keywords" LIKE '%Attorney%' OR
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'MIA' OR
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'KIA' OR
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Client' OR
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Craig''s Friends' OR
"urn:schemas-microsoft-comfficeffice#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?
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-comfficeffice#Keywords" LIKE '%Attorney%' OR
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'MIA' OR
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'KIA' OR
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Client' OR
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Craig''s Friends' OR
"urn:schemas-microsoft-comfficeffice#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?