• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Outlook Tips

Learning Microsoft Outlook One Tip At A Time

Diane Poremsky [Outlook MVP]

  • Home
  • Tips Archive
  • How to...
  • Beginner
  • Outlook.com

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
OR
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 updated on May 4, 2013.

Share this:

  • Twitter
  • Facebook
  • LinkedIn
  • More
  • Print
  • Tumblr
  • Reddit
  • Pocket
  • Pinterest

Related posts:

No related posts.

Subscribe
Notify of
3 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments

Primary Sidebar

Search OutlookTips

Training and one-on-one assistance

Do you need help setting up Outlook or want some one-on-one training? I'm available for hire. See Training and one-on-one assistance for fees and to check availability.

All-Time Most Popular Posts

  • Windows 7 and Vista Start Search field
    How to start Outlook in safe mode
  • outlook.com icon
    Delete a message stuck in Outlook's Outbox
  • How to use Outlook's Command line switches
  • Use Cleanviews switch to reset all views
    How to Reset the View on Outlook folders
  • Where are my Outlook Files?
  • Folder paths
    How to Find Folder Paths in Outlook Mailboxes
  • How to use Scanpst.exe to repair Outlook data files
  • Outlook's Missing Holidays
  • backstage page
    Where is File tab in Outlook?
  • Icons found in the Inbox, Message Headers, and Toolbars

Footer

Recent Posts

  • Log into multiple Outlook on the web accounts
  • Keeping Hackers out of Microsoft accounts
  • Microsoft Account Closure Email
  • Outlook on the web Quick Actions moved to the right
  • Automatically sign out of Outlook.com

Recent Bug List

Microsoft keeps a running list of issues affecting recently released updates at Fixes or workarounds for recent issues in Outlook for Windows.

Office Update History

Update history for supported Office versions is at Update history for Office

Resources

Ask questions and share your knowledge in Outlook Forums.

You Might Like

Where is File tab in Outlook?
Using Two-factor authentication
Where are my Outlook Files?
How to use Outlook's Command line switches

© 2003–2025 ยท Outlook Tips

wpDiscuz
You are going to send email to

Move Comment