Hot to speed up MailItems access
 

I get some properties from each MailItem in some folder:

_ItemsPtr spItems = spFolder-Items;
for (int j = 0; j spItems-Count; j++)
{
_MailItemPtr spMailItem = spItems-Item( j+1 );
if ( !spMailItem )
continue;

// SenderEmailAddress, SenderName, SentOn, Subject and Recipients
properties reading here
}

But this code is very slow. Only 130 messages per second even without
reading any properties.

How can I speed up mail items processing greatly? I need to process
thousands of emails...

Thanks.

How to speed up MailItems access
 

I've tried out this using ExMAPI - speed was increased greatly.

How to speed up MailItems access
 

Have a look at the Items.SetColumns methods.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Ivan" wrote in message
...
I've tried out this using ExMAPI - speed was increased greatly.

How to speed up MailItems access
 

Thanks, Dmitry!
When I tried to use this method in OOM it always returns null. I don't know
why.
Using MAPI, IMAPITable.SetColumns works fine.

How to speed up MailItems access
 

I am not sure what you mean - SetColumns in OOM does not return anything; it
simply tells Outlook which properties you are planning to access later from
the Items collection so that Outlook can make sure these properties get
cached from the underlying MAPI table.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Ivan" wrote in message
...
Thanks, Dmitry!
When I tried to use this method in OOM it always returns null. I don't
know
why.
Using MAPI, IMAPITable.SetColumns works fine.

How to speed up MailItems access
 

Sorry for the confusion. I mean that after calling SetColumns in OOM every
returned item from Items collection is null.

How to speed up MailItems access
 

What is your code?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Ivan" wrote in message
...
Sorry for the confusion. I mean that after calling SetColumns in OOM every
returned item from Items collection is null.

How to speed up MailItems access
 

// spFolder - MAPIFolderPtr
_ItemsPtr spItems = spFolder-Items;
spItems-SetColumns( "SenderName" );
for (int j = 0; j spItems-Count; j++)
{
_MailItemPtr spMailItem = spItems-Item( j+1 );
// spMailItem == null always, but without calling SetColumns everything
is ok.

if ( !spMailItem )
continue;
}
spItems-ResetColumns();

How to speed up MailItems access
 

I had no problem running rthe script below (I used OutlookSpy - click
"Script Editor" button, paste the script, click Run)
What is your version of Outlook? What happens if you declare spMailItem as
IDispatch instead of _MailItemPtr?
Note that your code will fail if you encounter an item other than MailItem
(such as ReportItem).

set Folder = Application.ActiveExplorer.CurrentFolder
set Items = Folder.Items
Items.SetColumns("SenderName")
for each Item in Items
Debug.Print Item.SenderName
next

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Ivan" wrote in message
...
// spFolder - MAPIFolderPtr
_ItemsPtr spItems = spFolder-Items;
spItems-SetColumns( "SenderName" );
for (int j = 0; j spItems-Count; j++)
{
_MailItemPtr spMailItem = spItems-Item( j+1 );
// spMailItem == null always, but without calling SetColumns everything
is ok.

if ( !spMailItem )
continue;
}
spItems-ResetColumns();