Outlook 2003 Querybuilder doesn't find everything it is supposed to find

[UncleBob]

I have solved part of this problem myself, but
need help on the rest.

Outlook has a slick feature called querybuilder
which enhances advanced find significantly (see
http://support.microsoft.com/?kbid=307922).

But, if I use advanced find to see every message
from John I see 15 messages. If I use query
builder, I only see 10.

After some reseach, I discovered that I had to
tell query builder to look for two things: from
contains John OR HaveRepliesSentTo contains John.

But this doesn't always work. I have another
e-mail where advanced find gets it, but query
builder doesn't.

When I open that e-mail, I see it comes from
"Staples Order Follow-Up
[[email protected]]".

But, I do not see "[[email protected]]"
when I use field chooser to see
From/HaveRepliesSentTo.

What is going on?

rberke

P.S. I will award 250 points for any useful
discussion. 500 points if someone tells me how to
make query builder work properly.

The header of the message looks like this

Return-Path: <[email protected]>
Received: from felicity.bizrate.com
(felicity.bizrate.com [216.52.244.197])
by hood.cnchost.com (ConcentricHost SMTP
MX 1.45)
id AAA23792 for <[email protected]>;
Thu, 8 Apr 2004 00:05:43 -0400 (EDT)
Message-Id:
<[email protected]>
Errors-To: <[email protected]>
Received: (qmail 21412 invoked from network); 8
Apr 2004 01:22:49 -0000
Received: from unknown (HELO hailey.bizrate.com)
(127.0.0.1)
by localhost.bizrate.com with SMTP; 8 Apr 2004
01:22:49 -0000
X-Habeas-SWE-1: winter into spring
X-Habeas-SWE-2: brightly anticipated
X-Habeas-SWE-3: like Habeas SWE (tm)
X-Habeas-SWE-4: Copyright 2002 Habeas (tm)
X-Habeas-SWE-5: Sender Warranted Email (SWE) (tm).
The sender of this
X-Habeas-SWE-6: email in exchange for a license
for this Habeas
X-Habeas-SWE-7: warrant mark warrants that this is
a Habeas Compliant
X-Habeas-SWE-8: Message (HCM) and not spam. Please
report use of this
X-Habeas-SWE-9: mark in spam to
<http://www.habeas.com/report/>.
To: (e-mail address removed)
Subject: Complete Your Staples Order Follow-Up
Survey
From: "Staples Order Follow-Up"
<[email protected]>
Date: Wed, 07 Apr 2004 18:22:06null
Reply-To: "Staples Order Follow-Up"
<[email protected]>
Content-Type: multipart/alternative;
boundary="______BoundaryOfDocument______"
MIME-Version: 1.0; Windows-1252
Content-Transfer-Encoding: 8bit
X-UIDL: 18314
Status: RO

 

[UncleBob]

My goal is really simple, I want a single search
folder that shows every e-mail to or from Mary,
Sue, or John.

After a lot more research I discovered something
interesting. Using a custom view to filter From
biz, the resulting SQL (which works) is

("urn:schemas:httpmail:fromname" LIKE '%z%' OR
"http://schemas.microsoft.com/mapi/proptag/0x00650
01f" LIKE '%z%')

I believe that query builder may not be as smart
as custom filters. My theory is that query
builder generates
"urn:schemas:httpmail:fromname" LIKE '%z%'

I have constructed several tests that seem to bear
this out.

Does this give anybody any ideas?



message

I have solved part of this problem myself, but
need help on the rest.

Outlook has a slick feature called querybuilder
which enhances advanced find significantly (see
http://support.microsoft.com/?kbid=307922).

But, if I use advanced find to see every message
from John I see 15 messages. If I use query
builder, I only see 10.

After some reseach, I discovered that I had to
tell query builder to look for two things: from
contains John OR HaveRepliesSentTo contains John.

But this doesn't always work. I have another
e-mail where advanced find gets it, but query
builder doesn't.

When I open that e-mail, I see it comes from
"Staples Order Follow-Up
[[email protected]]".

But, I do not see "[[email protected]]"
when I use field chooser to see
From/HaveRepliesSentTo.

What is going on?

rberke

P.S. I will award 250 points for any useful
discussion. 500 points if someone tells me how to
make query builder work properly.

The header of the message looks like this

Return-Path: <[email protected]>
Received: from felicity.bizrate.com
(felicity.bizrate.com [216.52.244.197])
by hood.cnchost.com (ConcentricHost SMTP
MX 1.45)
id AAA23792 for <[email protected]>;
Thu, 8 Apr 2004 00:05:43 -0400 (EDT)
Message-Id:
<[email protected]>
Errors-To: <[email protected]>
Received: (qmail 21412 invoked from network); 8
Apr 2004 01:22:49 -0000
Received: from unknown (HELO hailey.bizrate.com)
(127.0.0.1)
by localhost.bizrate.com with SMTP; 8 Apr 2004
01:22:49 -0000
X-Habeas-SWE-1: winter into spring
X-Habeas-SWE-2: brightly anticipated
X-Habeas-SWE-3: like Habeas SWE (tm)
X-Habeas-SWE-4: Copyright 2002 Habeas (tm)
X-Habeas-SWE-5: Sender Warranted Email (SWE) (tm).
The sender of this
X-Habeas-SWE-6: email in exchange for a license
for this Habeas
X-Habeas-SWE-7: warrant mark warrants that this is
a Habeas Compliant
X-Habeas-SWE-8: Message (HCM) and not spam. Please
report use of this
X-Habeas-SWE-9: mark in spam to
<http://www.habeas.com/report/>.
To: (e-mail address removed)
Subject: Complete Your Staples Order Follow-Up
Survey
From: "Staples Order Follow-Up"
<[email protected]>
Date: Wed, 07 Apr 2004 18:22:06null
Reply-To: "Staples Order Follow-Up"
<[email protected]>
Content-Type: multipart/alternative;
boundary="______BoundaryOfDocument______"
MIME-Version: 1.0; Windows-1252
Content-Transfer-Encoding: 8bit
X-UIDL: 18314
Status: RO