Outlook 2003 Contact Filters

J

J Cope At Stratis

I created three categories to organize my contacts: Agents, Clients, and
Newsletter. I also have uncategorized contacts.

Everyone in Agents is also in Newsletter.
Everyone in Clients is also in Newsletter.

I am trying to construct a filter to show all of the contacts that are in
Newsletter, but who are NOT in either of the other two defined categories.
The filter generator comes up with the following:

("urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" LIKE '%Newsletter%' OR
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Agents' OR
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Clients')

Because the operators are 'OR', the filter does not work. For simplicity I
removed the Newsletter category from the filter; I figure if I can filter the
Agents and Clients I can sort by Category to see the remaining members of
Newsletter:

("urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Agents' OR
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Clients')

This filter does not work either, I thought because of the 'OR'. I changed
it to 'AND' but still had no luck.

Any help at all with this would be appreciated.
Thanks!
 
J

Judy Gleeson MVP Outlook

Can I suggest a slightly different approach....

use Category for the type of person (in your case Agent or Client) then make
a new yes/no field for Newsletter. Check the box for anyone who's supposed
to get the newsletter. Then you can make a view of those who should get the
newsletter regardless of their category.

The Table Views (eg Phone List) are the best bet. Use the Field Chooser -
New Field is on the bottom.


Judy Gleeson [MVP Outlook]
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top