+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    01-07-2009
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2007
    Posts
    9

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

    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

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,423

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

    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.

  3. #3
    Registered User
    Join Date
    01-07-2009
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2007
    Posts
    9

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

    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!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Acces Global Address List (GAL) - Outlook via userform textbox
    By tikku.kumbo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2018, 04:24 AM
  2. Global address list in Outlook
    By jackcell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-28-2017, 05:08 AM
  3. Outlook script to forward emails based on senders' address
    By Project_paw in forum Outlook Formatting & Functions
    Replies: 5
    Last Post: 02-03-2016, 12:16 PM
  4. Outlook Rules - moving emails from a sender in a specific address book
    By UKRyan in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 12-22-2014, 11:12 AM
  5. Read details from Global Address Book in Outlook into Excel
    By mkvassh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-03-2014, 12:26 PM
  6. Get name details from Global Address List
    By adyteo in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2013, 05:45 AM
  7. Outlook Macros to extract info from multiple emails, add to excel...
    By bnasty in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2012, 02:23 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1