Filter out Birthdays AND Anniversarys

[Graeme]

I'd like to filter out Birthdays AND Anniversarys. It seems I can do one, or
the other, but not both. I use the Advanced Filter tab, but I'll cut to the
chase and show you the SQL is makes:

("urn:schemas:httpmail:subject" <> 'Anniversary')

Will turn off anniversaries, and changing the key word will turn off
birthdays, but adding the two together in the advanced filter tab produces
this one...

("urn:schemas:httpmail:subject" <> 'Anniversary' OR
"urn:schemas:httpmail:subject" <> 'Birthday')

which seems to let them both through, as does this one I created myself
directly in the SQL tab

("urn:schemas:httpmail:subject" <> 'Anniversary' AND
"urn:schemas:httpmail:subject" <> 'Birthday')

What am I missing? TIA. Graeme

 

[Diane Poremsky [MVP]]

Try AND:
("urn:schemas:httpmail:subject" <> 'Anniversary' AND
"urn:schemas:httpmail:subject" <> 'Birthday')

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

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205

 

[Graeme]

Thank you for responding Diane.

(1) I very carefully cut/paste your SQL into the last tab, but it had no
effect. Both anniversaries and birthdays got through

(2) I ran regedit to create the value for query builder, built the query,
and it worked produced this:

("urn:schemas:httpmail:subject" <> 'birthday' AND
"urn:schemas:httpmail:subject" <> 'anniversary')

which actually works!

As far as I can tell there is no difference in the SQL, but I am not going
to argue.

Once again, thankyou. Graeme

Try AND:
("urn:schemas:httpmail:subject" <> 'Anniversary' AND
"urn:schemas:httpmail:subject" <> 'Birthday')

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

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205

I'd like to filter out Birthdays AND Anniversarys. It seems I can do one,
or
the other, but not both. I use the Advanced Filter tab, but I'll cut to
the
chase and show you the SQL is makes:

("urn:schemas:httpmail:subject" <> 'Anniversary')

Will turn off anniversaries, and changing the key word will turn off
birthdays, but adding the two together in the advanced filter tab produces
this one...

("urn:schemas:httpmail:subject" <> 'Anniversary' OR
"urn:schemas:httpmail:subject" <> 'Birthday')

which seems to let them both through, as does this one I created myself
directly in the SQL tab

("urn:schemas:httpmail:subject" <> 'Anniversary' AND
"urn:schemas:httpmail:subject" <> 'Birthday')

What am I missing? TIA. Graeme

 

[Diane Poremsky [MVP]]

Yeah, we've discovered that it errors sometimes when you paste.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205

Thank you for responding Diane.

(1) I very carefully cut/paste your SQL into the last tab, but it had no
effect. Both anniversaries and birthdays got through

(2) I ran regedit to create the value for query builder, built the query,
and it worked produced this:

("urn:schemas:httpmail:subject" <> 'birthday' AND
"urn:schemas:httpmail:subject" <> 'anniversary')

which actually works!

As far as I can tell there is no difference in the SQL, but I am not going
to argue.

Once again, thankyou. Graeme

Try AND:
("urn:schemas:httpmail:subject" <> 'Anniversary' AND
"urn:schemas:httpmail:subject" <> 'Birthday')

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

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205

I'd like to filter out Birthdays AND Anniversarys. It seems I can do
one,
or
the other, but not both. I use the Advanced Filter tab, but I'll cut to
the
chase and show you the SQL is makes:

("urn:schemas:httpmail:subject" <> 'Anniversary')

Will turn off anniversaries, and changing the key word will turn off
birthdays, but adding the two together in the advanced filter tab
produces
this one...

("urn:schemas:httpmail:subject" <> 'Anniversary' OR
"urn:schemas:httpmail:subject" <> 'Birthday')

which seems to let them both through, as does this one I created myself
directly in the SQL tab

("urn:schemas:httpmail:subject" <> 'Anniversary' AND
"urn:schemas:httpmail:subject" <> 'Birthday')

What am I missing? TIA. Graeme