How to filter a view base on OR not AND conditions

[Rodger in SF]

Recently migrated to Outlook 2007. The process sucked all of my old Outlook
address book entries into my Contacts folder. Now my Contacts view has a
bunch of entries that only contain email addresses and nothing more. I'm
trying to create a Contact view that does not display the email only entries.
I'd like to create a filter that only show entries with a phone or address in
them, something like this:

home phone IS NOT empty OR
business phone IS NOT empty OR
mailing address IS NOT empty

But it seems like Outlook only creates AND conditionals - i.e.:

home phone IS NOT empty AND
business phone IS NOT empty AND
mailing address IS NOT empty

Which clearly blocks out many entries I would like to see.

I can't filter based on the email field since many of the entries with a
phone number or address also have an email.

Any ideas would be appreciated on how to create a view that hides the email
only entries.
thanks - rodger

 

[Diane Poremsky [MVP]]

Did you try SQL or QueryBuilder tabs?

QueryBuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm

 

[Richard]

It sounds like your import went south somewhere try reimporting and map the
custom fields.

Richard

 

[Rodger in SF]

Diane-

Thanks a bunch. I figured SQL could do the task, but sadly (or not) I don't
know SQL.

But Query Builder did the trick. Although for Outlook 2007 I had to edit
the registry under
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\QueryBuilder

Instead of
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\QueryBuilder
like your tip for Outlook 2003 says.

You'd think MS would just set it up this way in the 1st place. I mean if
you're gonna want to AND, you'll probably want to OR sooner or later.

 

[Rodger in SF]

Richard,

Thanks for the reply. I'm not using any custom fields, and everything
imported fine. The real problem is that the Outlook filter only lets you
specify AND conditions - which is plain silly on their part. But adding
Query Builder like Diane suggested above gets around that limitation. But
why make users jump through that hoop in the first place? It's a
shortsighted design limitation from MS.

 

[Diane Poremsky [MVP]]

to edit sql, create filters in one of the other tabs and then switch tp sql
and check the box to edit it - just change AND to OR:

("urn:schemas:httpmail:displayto" = '%[email protected]%' OR
"urn:schemas:httpmail:displayto" = '%[email protected]%')