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

Outlook Tips

Learning Microsoft Outlook One Tip At A Time

Outlook 2013 Absolute Beginner's Guide 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

Subscribe to Outlook Tips by Email

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.

Popular Posts this Week

  • Where is File tab in Outlook?
    Where is File tab in Outlook?
  • Understanding Tasks and To-Do List
    Understanding Tasks and To-Do List
  • How to Find Folder Paths in Outlook Mailboxes
    How to Find Folder Paths in Outlook Mailboxes
  • Icons found in the Inbox, Message Headers, and Toolbars
    Icons found in the Inbox, Message Headers, and Toolbars
  • How to bulk move Outlook folders
    How to bulk move Outlook folders
  • How to Reset the View on Outlook folders
    How to Reset the View on Outlook folders
  • Change or cancel meetings without sending update messages
    Change or cancel meetings without sending update messages
  • "Who created the appointment?"
    "Who created the appointment?"
  • Prevent Accidentally Sending an Email Message
    Prevent Accidentally Sending an Email Message
  • Setting a fixed Column Width in Outlook
    Setting a fixed Column Width in Outlook

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
  • Icons found in the Inbox, Message Headers, and Toolbars
  • open an outlook data file
    Open an existing personal data file (*.pst) in Outlook
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Footer

Recent Posts

  • Outlook on the web Quick Actions moved to the right
  • Automatically sign out of Outlook.com
  • Quick Actions in Outlook
  • Outlook Autocomplete Bug
  • Outlook on the web Address Book sort order

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.

Translate

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–2023 ยท Outlook Tips

wpDiscuz
You are going to send email to

Move Comment