Search Mac Outlook 2011 Mail with Raw Queries

You can gain a lot of control over searching your mail by using "Raw Queries" passed straight to the Spotlight Engine.

To input a "Raw Query" go to "Advanced Find" - Shift-Command F. And switch the Query Type on the left side of the input box to "Raw Query", it's at the bottom of the list.

From there you can start assembling queries like:

com_microsoft_outlook_author_email_addresses == "*@example.com"c || kMDItemAuthors == "*Paul*" && kMDItemRecipients != "*Roy*"

Queries accept the boolean operators || for "or" and && for "and." Splat (*) is the wildcard character. By appending a "c" after a quoted search value the search becomes case insensitive.

These are all the fields I'm aware of, but there are probably more:

com_microsoft_outlook_author_email_addresses == someone@example.com

This field matches on the e-mail address of the author

kMDItemAuthors == "*Richard*"

This field matches on the name of the author

kMDItemRecipients == "John Smith"c

This field matches on the name of a recipient

com_microsoft_outlook_accountID

Numeric account ID

com_microsoft_outlook_attachments

List of attached files

com_microsoft_outlook_categories

Numeric categories

com_microsoft_outlook_completed

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_flagged

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_folderID

Numeric folder ID

com_microsoft_outlook_forwarded

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_has_attachments

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_has_reminder

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_has_text_content

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_hasDueDate

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_hasStartDate

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_isFromMailingList

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_messageSent

Timestamp in format: 2013-10-24 09:38:23 -0800

com_microsoft_outlook_primaryCategory

Numeric category?

com_microsoft_outlook_priority

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_recordID

Numeric record ID

com_microsoft_outlook_redirected

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_repliedTo

Boolean value? 0 for false, 1 for true

com_microsoft_outlook_size

Unsure, boolean?

com_microsoft_outlook_unread

Boolean value? 0 for false, 1 for true

I'll update as I find more.