Tip 49: Creating Advanced Filters

Outlook has a very powerful filter available to use with Advanced Find, Views, Automatic Formatting or Search Folders. You can add conditions on one or more of Filter's tabs and the conditions are joined with AND. In many fields you can use AND or OR operators within the same criteria:

Name contains Sue or Bill

Some fields will need a comma for OR:
Subject contains outlook, IMAP

You can't OR different criteria together, even on the Advanced tab.
Name contains Sue
Email address contains @microsoft.com

Won't work. Different criteria always uses AND. However, if you enable the QueryBuilder you can use AND. See Using QueryBuilder to learn how to enable QueryBuilder.

These filters will work on Views, Advanced Find, Automatic Formatting and in Outlook 2003 and up, with Search Folders. Some of the tricks, like the comma one, work in Find too.

Published October 16, 2003. Last reviewed on May 4, 2013.

  • Dinovici

    Hi Diane, I work for an email company and we deploy hundred of thousands of emails. The replies arrive in my inbox - it's cluttered!

    e.g. we send as email-sender@domain.xx and the subscribers reply to myaddress@domain.yy from subscriber@domain.zz.

    Is there any way to filter the emails from email-sender@domain.xx ?

    Cheers, Vic

  • D Poremsky

    Is the address in the message body or in the message header (internet header)? if yes, there are ways to filter it. If the address is not in the message, no, unless there is a subject or something else unique you can filter on.

  • http://www.slipstick.com/ D Poremsky

    What version of Outlook are you using?