Hot to speed up MailItems access Ivan 6/15/2007 6:47:03 AM 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.

RE: How to speed up MailItems access Ivan 6/15/2007 11:50:01 AM I've tried out this using ExMAPI -> speed was increased greatly.

Re: How to speed up MailItems access "Dmitry Streblechenko" <dmitry[ at ]dimastr.com> 6/15/2007 6:28:36 PM Have a look at the Items.SetColumns methods. Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Ivan" <Ivan[ at ]discussions.microsoft.com> wrote in message news:CFABA54C-E7D8-43A2-8BD1-E105A424BA2D[ at ]microsoft.com... [Quoted Text] > I've tried out this using ExMAPI -> speed was increased greatly.

Re: How to speed up MailItems access Ivan 6/26/2007 5:04:00 AM 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.

Re: How to speed up MailItems access "Dmitry Streblechenko" <dmitry[ at ]dimastr.com> 6/26/2007 5:02:23 PM 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" <Ivan[ at ]discussions.microsoft.com> wrote in message news:3861A9EB-E4DF-4D7C-9A2A-7AB03CF696FE[ at ]microsoft.com... [Quoted Text] > 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. >

Re: How to speed up MailItems access Ivan 6/27/2007 3:38:00 AM Sorry for the confusion. I mean that after calling SetColumns in OOM every returned item from Items collection is null.

Re: How to speed up MailItems access "Dmitry Streblechenko" <dmitry[ at ]dimastr.com> 6/27/2007 6:55:17 AM What is your code? Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Ivan" <Ivan[ at ]discussions.microsoft.com> wrote in message news:770F48FD-A2F0-48FC-A194-C073E3A909BE[ at ]microsoft.com... [Quoted Text] > Sorry for the confusion. I mean that after calling SetColumns in OOM every > returned item from Items collection is null. >

Re: How to speed up MailItems access Ivan 6/27/2007 8:54:00 AM // 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();

Re: How to speed up MailItems access "Dmitry Streblechenko" <dmitry[ at ]dimastr.com> 6/27/2007 4:39:11 PM 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" <Ivan[ at ]discussions.microsoft.com> wrote in message news:2DA20E41-8A48-4AAC-87C0-0E636026D1EC[ at ]microsoft.com... [Quoted Text] > // 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();