code to only get info from outlook global address for emails in list

[QIP]

Hello,

I was looking for a way to capture contacts info in excel for emails i have, i found below code in this website: (cant post link due to low number of posts) which dumps the whole GAL, for the size of GAL and info i need literally took 4+ hours... is there a way to modify the code to get info for emails in a range, say column A?

I tried to play with it, but didn't work, the code below is the original code without my apparently useless code added code (i managed to modify other aspects as well to retrieve more info):

currently the code below retrieves many fields, i already changed the fields from my side successfully, now instead of dumping everything including the email (PrimarySmtpAddress) i want to provide the emails in a list and make the code retrieve related info as customized, hopefully reducing run time

PS: to use the code you need to set a reference to Outlook object model in Excel's Tools, in the VBA developer window

Please Login or Register  to view this content.

Thanks
Q

[Kenneth Hobson]

You should be able to post a link after 5 posts. If not, you can paste the last part of the url less the .html to the first backslash. e.g. 1280045-code-to-only-get-info-from-outlook-global-address-for-emails-in-list

Using an array method, of 135k entries with 93k records, this took 14 minutes. I could trim the array down but unless there is a memory overflow error, it should work ok.

Please Login or Register  to view this content.

[QIP]

Thanks Kenneth!

The link is slipstick.com/developer/code-samples/export-exchange-gal-excel/

I ran the code today, in its original format what you posted it ran as well in less than 15 minutes for my records.

when i modified it expanding it to 7 elements, adding .GetExchangeUserManager.Name and .GetExchangeUserManager.PrimarySmtpAddress (phone number removed) it took approximately 2 1/2 hours, yet still very happy

thanks a lot!