Extracting Contacts list in Global Address List

**suryaprasad** · 11-06-2008, 02:03 AM

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.

**Leith Ross** · 11-06-2008, 02:21 AM

Hello suryaprasad,

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

Sincerely,
Leith Ross

**suryaprasad** · 11-06-2008, 02:44 AM

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

**Paul** · 11-06-2008, 02:52 AM

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?

**suryaprasad** · 11-06-2008, 05:09 AM

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

**Leith Ross** · 11-06-2008, 05:31 AM

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

**DonkeyOte** · 11-06-2008, 05:35 AM

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.

**suryaprasad** · 11-07-2008, 02:41 AM

Hi DonkeyOte,

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

Please help

Regards
Surya

**Leith Ross** · 11-07-2008, 04:41 AM

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.

**Leith Ross** · 10-17-2010, 12:28 AM

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

**henrikop** · 11-25-2010, 01:43 PM

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

**nsontag** · 06-10-2011, 06:47 PM

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