SQL filtering for Outlook 2003

[Triacona]

Dear All,

Your help would be greatly appreciated in the following request:

I want to filter e-mails from certain contacts, and include the replys I sent to them (so all sent e-mails to certain contacts)
Kind of like the find related messages.

I have tried search folders, but it will not allow me to search on the FROM and TO simultaneously, it is either the one or the other.

So I have resorted to the SQL tab in the filter form.

1. My first question is, is there any easy obvious answer to this like modifying the search folder/filter in a specific way.

2. What SQL code would I need for this?

Any help would really be appreciated

Kind regards

Triacona

 

[cmeagan656]

Are these contacts that are in your Contacts folder? If so, why don't you use the built in "Activity" feature. I can't recall exactly where it is in Outlook 2003 but I think that there is a separate tab for it. In Outlook 2007 you open the Contact and click on "Activities".

The default is to search all folders, including Calendar, Inbox, and Sent Items. You can search specific folders if you prefer (although you can only search one folder at a time that way). You can choose the fields that you want to show and then sort by any of those fields.

The feature will find any items related to the contact that you are searching, even if they were only CC'd to.

One thing with this method though is that the first time that you use it on a contact it can take quite a while to search and index the results depending on the size of your mail store.

Hope this helps.

Please help us help you. Read Tek-Tips posting polices before posting.
Canadian members check out Tek-Tips in Canada for socializing, networking, and anything non-technical.

 

[Triacona]

Thank you for your reply cmeagan656.

I have found a way round my problem, although it is not perfect...

In came in the answer of check what the search criteria for "Find Related Messages", so in the advanced tab within the serach criteria function add:

Conversation contains "your string here"

But the problem is, I use HD in the string search and that brings everything with HD, lower case and upper.

My question is this:
How do you specify lower or upper case in the search string?

Any further help will be greatly appreciated

Kind regards

Triacona