Reading Outlook e-mail data is slow

[rscsmith]

Hi Folks,

I am reading data from Outlook in to a spreadsheet. At present, I'm only achieving about 1 per second. I have done some experimentation and found that it is only when one starts reading in SenderName, Subject, etc that it really slows down. I assume this is because it is being retrieved from the Exchange server each time I request a piece of information. Is there a quicker method, perhaps retrieving all the data at once?

My code follows. I have deleted most of the irrelevant code to test the speed issue and was slowly adding it back in. I've highlighted two lines that, when added, really slow the code down. Before these were added, the macro ran 74 e-mails in about 2 seconds. I'm using Office 2007.

Please Login or Register  to view this content.

Any advice would be very welcome.

Best regards, Rob.

[Tinbendr]

You don't have objEmail defined. (So it gets defined as a variant) Try Diming it as a MailItem.

[rscsmith]

Thanks David.

I gave it a go and it did improve performance a bit (down to 80 items in 40 seconds). It's still not going particularly quickly, but perhaps that is a limitation of my connection to the Exchange server.

Best regards, Rob.