Correct, PST is not subject to this limitation.
There is no way to clear the cache.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"deko" wrote in message
...
Thanks for the heads up, Dmitry.

I'm wondering if there's a way to force the cache to clear itself. Also,
I assume on a local Outlook PST there are no cache issues.

From reading the MSDN article, the Restrict method seems to the better
option for my needs: "The Restrict method is significantly faster if there
is a large number of items in the collection, especially if only a few
items in a large collection are expected to be found." This is the case
when searching a large Inbox for messages matching one or two email
addresses.

What's really interesting is the ability to use an SQL query as the
filter:

The example in the MSDN article is this:
filter = /mapi/proptag/0x0037001f"" =
'the right ""stuff""'"

What is that hyperlink? Is that just part of the example in the MSDN
article?

How about: "@SQL = "SELECT EmailAddress from tblContactEmailAddresses" -
would this work as a Restrict filter?


"Dmitry Streblechenko" wrote in message
...
Don't use Restrict unless the restriction stays the same: Exchange caches
restrictions for a week by default. Cached restriction arae updated every
time an item in the folder iss modified/added/deleted.
Unless you really want the restriction to be cached, do not use Restrict
against an Exchange store.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"JP" wrote in message
...
In addition to what Dmitry suggested, you could also use the Restrict
Method to limit you search to ONLY those items in the Inbox that match
your criteria. This would significantly reduce the amount of time
spent looping through a folder.

See
http://msdn.microsoft.com/en-us/library/bb220369.aspx


--JP

On Jun 5, 6:33 pm, "deko" wrote:
I just upgraded to Office 2007 and would like to refactor my automation
code
to improve speed and perhaps add some new functionality.

My Access 2007 database has code that searches Outlook 2007 for email
messages. The database contains Contacts, each with one or more email
addresses. The current code loops through each message in the Outlook
Inbox
trying to match one of the Contact's email addresses with the
SenderEmailAddress property of each mail item. When a match is found,
the
message subject and other data is added to a recordset and displayed in
a
datasheet in Access.

Here's an abbreviated example:

Dim olapp As Outlook.Application
Dim olmi as Outlook.MailItem
Dim olitms as Outlook.Items
Dim objItem As Object

Set olapp = New Outlook.Application
Set olns = olapp.GetNamespace("MAPI")
Set olFolder = olns.GetDefaultFolder(olFolderInbox)
Set olitms = olFolder.Items

Do While Not rstContactAddresses.EOF
For Each objItem in olitms
If TypeOf objItem Is Outlook.MailItem Then
Set olmi = objItem
If olmi.SenderAddress = rstContactAddresses!EmailAddress
Then
Call AddToRecordset(olmi.whatever)
End if
End if
Next objItem
Loop

Is there a better way to do this with VBA? Is it worth trying to use
C# and
VSTO here? Is it possible to tap into the indexed Outlook email search
feature? Other new stuff in 2007 that can help?

Thanks in advance.