Customise current view

  • Thread starter Thread starter JM
  • Start date Start date
J

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?
 
What is the syntax you used in the SQL tab for adding another category?
 
I entered :

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
("urn:schemas-microsoft-com:office:office#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-com:office:office#Keywords"
<> 'Personal' OR "urn:schemas-microsoft-
com:office:office#Keywords" <> 'Birthdays'))

which is where it didn't work.
 
Try changing that last OR to AND.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
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
 
Back
Top