Customise current view

[JM]

I have a number of categories set up on my outlook.
However i don't want the appointments in 3 of these
categories to be visible at certain times. The ones i do
want visible are those with the default null value in the
categories field.

i created a filter under view, current view, customise
current view, filter, more choices tab, and inserted 1
category that i didn't want visible. i then went into the
SQL tab and changed the syntax from ='personal' to
<>'personal' - this worked by displaying everything in my
outlook except for appointments with personal as the
category. However, when i then tried to add another
category i wanted omitting it went back to displaying
everything.

Can anyone help?

 

[Sue Mosher [MVP-Outlook]]

What is the syntax you used in the SQL tab for adding another category?

 

[Guest]

I entered :

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
("urn:schemas-microsoft-comfficeffice#Keywords"
<> 'Personal')

which works for 1 catergory, however for more than 1 I
entered:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("urn:schemas-microsoft-comfficeffice#Keywords"
<> 'Personal' OR "urn:schemas-microsoft-
comfficeffice#Keywords" <> 'Birthdays'))

which is where it didn't work.

 

[Sue Mosher [MVP-Outlook]]

Try changing that last OR to AND.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Thanks for that i think its worked, HOWEVER, i now can't
see all my business entries which have a default category
of NULL, i am sure this was working until today !!

JM