Finding Journal Entries by Date

[Guest_imported]

Does anyone know how to find journal entries in outlook by a specific date? The only way I can find what I'm looking for is by looping through every journal entry I have in outlook and checking the creation date which is very inefficient. What I have looks something like this:

Set objNs = Application.GetNamespace("MAPI&quot
Set objFolderJournal = objNs.GetDefaultFolder(olFolderJournal)


For i = 1 To objFolderJournal.Items.Count
Set JournalEntry = objFolderJournal.Items(i)

'MsgBox (JournalEntry.CreationTime)
'MsgBox (JournalEntry.Body)
Next i

 

[LLudden]

From what I see, there is no better way of doing it, since Outlook isn't based on a client/server model. If you have several such queries to run in a given session, and many journal entries to search, it may be faster to copy them all into a temp table then run queries on that table.