+ Reply to Thread
Results 1 to 12 of 12

Extracting Contacts list in Global Address List

  1. #1
    Registered User
    Join Date
    06-11-2008
    Location
    Hyderabad
    Posts
    54

    Extracting Contacts list in Global Address List

    Hi,

    Can Anyone help me to extract the contact list from global address list of the Outlook provided through a VBA code which should be ported to excel automatically after getting the Details from the Outlook.

    Is there any chances of getting such Information through VBA code which can be written in Microsoft outlook.

    Please help me that would make my work bit easier.


    Thanks

    Surya.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello suryaprasad,

    What information due you want to retrieve from the address book for the contact name?

    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    06-11-2008
    Location
    Hyderabad
    Posts
    54
    Hi Lieth Ross,

    When i run a the VBA it should get the Information of :

    Title FirstName MiddleName LastName Suffix Company Department JobTitle BusinessStreet BusinessStreet2 BusinessStreet3 BusinessCity BusinessState BusinessPostalCode BusinessCountry HomeStreet HomeStreet2 HomeStreet3 HomeCity HomeState HomePostalCode HomeCountry OtherStreet OtherStreet2 OtherStreet3 OtherCity OtherState OtherPostalCode OtherCountry AssistantsPhone BusinessFax BusinessPhone BusinessPhone2 Callback CarPhone CompanyMainPhone HomeFax HomePhone HomePhone2 ISDN MobilePhone OtherFax OtherPhone Pager PrimaryPhone RadioPhone TTYTDDPhone Telex Account Anniversary AssistantsName BillingInformation Birthday BusinessAddressPOBox Categories Children DirectoryServer EmailAddress EmailType EmailDisplayName Email2Address Email2Type Email2DisplayName Email3Address Email3Type Email3DisplayName Gender GovernmentIDNumber Hobby HomeAddressPOBox Initials InternetFreeBusy Keywords Language1 Location ManagersName Mileage Notes OfficeLocation OrganizationalIDNumber OtherAddressPOBox Priority Private Profession ReferredBy Sensitivity Spouse User1 User2 User3 User4 WebPage

    All the Details which are uploaded in the history of GAL

    Thanks

    Surya

  4. #4
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,826
    My guess is it's possible to get this information, and if anyone can Leith can!!... but wouldn't it be easier to talk to your IT department for an export of the global address list with all of the properties for each address that you're looking for?

  5. #5
    Registered User
    Join Date
    06-11-2008
    Location
    Hyderabad
    Posts
    54
    Thanks for the Advice but its a report base oriented we have additions & deletions in contacts for which the same cannot be requested to IT person every time when ever a revision is required.

    Could you help me in this plz

    Thanks
    Surya

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello suryaprasad,

    I have made some progress on this. But, it is early in the morning here, about 1:30 am, and I am to tired to continue. I will resume this in the morning though.

    Sincerely,
    Leith Ross

  7. #7
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,529
    retrieving the contents from an address book per se is relatively straightforward, eg below (run from XL) would pull the contents of my Contacts address list into my spreadsheet ... unfortunately I'm not on an exchange and don't thus have access to a Global Address List so I'm not sure how easy it is to alter the below ... ie if you can just change the Select Case criteria to be the name of the Global Address List... in the example I'm obviously only returning the actual names and addresses but obviously this could be extended to return multiple fields as you request.

    Please Login or Register  to view this content.
    I hope this points you in the right direction if nothing more...

    EDIT: Leith - sorry not meant to be treading on toes - your post wasn't there when I began composing mine... to reiterate mine may not even work for GALs.
    Last edited by DonkeyOte; 11-06-2008 at 05:37 AM.

  8. #8
    Registered User
    Join Date
    06-11-2008
    Location
    Hyderabad
    Posts
    54

    Unhappy

    Hi DonkeyOte,


    Thanks for the Reply its not working and also it should port the data automatically into excel file.

    Please help

    Regards
    Surya

  9. #9
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello suryaprasad,

    This macro will export the contents of all items in the GAL with the exception of Outlook constants, object references, and boolean expressions, for contact in it. The macro below has already been added to the attached workbook. You can call the macro using ALT+F8 and selecting ExportGAL from the list.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  10. #10
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA Code Needed for Extracting Contacts list in Global Address List

    Hello s.sabari,

    Welcome to the Forum!

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

    As a new member, please take some time to familiarize yourself with the rules.
    Click Here for Forum Rules

  11. #11
    Registered User
    Join Date
    11-25-2010
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: VBA Code Needed for Extracting Contacts list in Global Address List

    I used the excel sheet, but it only does read my local contacts and not the exchange GAL. Who am i doing wrong?

  12. #12
    Registered User
    Join Date
    10-07-2010
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: VBA Code Needed for Extracting Contacts list in Global Address List

    I tried impementing the solution from this thread, but the solution extracts contacts from my local address book rather than the GAL. Does anyone know how to extract contact info from the GAL?

    Thanks,

    Nolan
    Last edited by nsontag; 06-10-2011 at 06:59 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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