Items.Find -> To -> With mutliple e-mails

[GregR]

I'm trying to do a find against a folder, on the "to" field, against a bunch
of e-mails. If the "To" has one e-mail, it works fine. If it has more than
one (e.g., (e-mail address removed); (e-mail address removed); (e-mail address removed)) it doesn't work.

Example:


_MailItem mailItemTest = oItems.Find("[To] = '(e-mail address removed)'") as _MailItem;

(The above oItems points to a valid folder).

So with this example, any messages in the folder that have a single "to" of
"(e-mail address removed)" will return the first found (and FindNext the next). If any
of the messages in the folder contain "(e-mail address removed)" and any other e-mails
in the to, that message is not returned.

I'm trying to find all e-mails with a "to" of a specific address - but most
will have that one plus others.

Any ideas here? I tried wild carding it, without luck. I've written code
to iterate through and do my own search, but the folder can have a lot of
e-mails, so that is very slow and I quickly run into the outlook connect
limit.

Thanks,
-Greg

 

[Ken Slovak - [MVP - Outlook]]

Outlook version? Even if this isn't for Outlook 2007 where you can use the
new content searching you can use SQL syntax in a Find/Restrict by prefacing
the SQL search with "@SQL=".

In that case you use the DASL property tag, so it would be
"http://schemas.microsoft.com/mapi/proptag/0x0E04001E" or
"urn:schemas:httpmail:displayto". The filter would look something like this:

string filter = "@SQL=" + "\"" + "urn:schemas:httpmail:displayto" + "\"" + "
LIKE '%[email protected]%' ";