One of Outlook’s (fairly well) hidden secrets is the SQL Tab on the Filter dialog in the Outlook 2002 and 2003 Custom View Organizer. This article explores how to use the SQL Tab when customizing Outlook Views to create advanced queries or filters in Outlook to group, sort and filter your Outlook data depending on the task at hand.

Note: this article does not apply if you’re using Outlook 2000!

We look at:

Defining the Problem – The Task at Hand

Importing the Sample Data

Identifying the Filter Conditions

Defining the Query in Boolean Terms

Creating and Modifying the View

 

Note 1: This article is available in PDF Format for easier reading. Click here to open this.

Note 2: If you are not familiar with the basics of creating Outlook Views, you might like to review the following article first:

Profiling Contacts using the Outlook Forms Designer - 02