Filtering an outlook view on all replied or forwarded messages

F

fredandc

I just wanted to post a quick howto on this, as it took some digging
to get the syntax right:

In the Filters dialog, in the SQL tab, use the following:

http://schemas.microsoft.com/mapi/proptag/0x10810003 = 102 or
http://schemas.microsoft.com/mapi/proptag/0x10810003 = 103 or
http://schemas.microsoft.com/mapi/proptag/0x10810003 = 104

This will filter the view on items that have been replied to or
forwarded. The 102 means replied, 103 means reply to all and 104
means forwarded.

If you want just the messages that have not been replied or forwarded:

NOT (http://schemas.microsoft.com/mapi/proptag/0x10810003 = 102 or
http://schemas.microsoft.com/mapi/proptag/0x10810003 = 103 or
http://schemas.microsoft.com/mapi/proptag/0x10810003 = 104)


To get the Filter dialog, from http://blogs.msdn.com/andrewdelin/archive/2005/05/11/416312.asp

Firstly, I recommend you add the [Filter...] button to a toolbar in
Outlook. To do this, right-mouse-click on an empty area of the toolbar
area at the top of Outlook, and select Customize from the menu. Pick
the Commands tab and then select View in the Categories list. On the
right, scroll down the Commands list until you see 'Filter' and then
drag this entry up, up and away to a toolbar spot where you'd like it.
You should now have a Filter button in your toolbar at the top of
Outlook. You can close the Customize dialog.
The Filter dialog is a somewhat hidden but powerful tool for finding
all kinds of Outlook items. It is organized as four tabs: Messages,
More Choices, Advanced and SQL. I recommend you play with this dialog
if it's not familiar to you. When you apply a Filter on a folder, you
will see a small legend above your email (on the right) saying 'Filter
Applied' - a hint that not all items are being shown! You use the
Clear All button in the Filter dialog to remove the filter so you can
see everything again.
I prefer to use the Advanced and SQL tabs of the Filter dialog because
you can establish very specific queries that meet your needs. You will
need to check 'Edit these criteria directly' to enter SQL queries.
 
Joined
Mar 9, 2012
Messages
2
Reaction score
0
Hello,

these lines of SQL script[?] have not worked for me.

Has anyone else any suggestions for getting replied to/forwarded messages filtered out or in?
 
Joined
Dec 14, 2023
Messages
1
Reaction score
0
Works perfectly fine. Just copy and delete the unwanted spaces (This sometime happens while copying)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top