View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Extracting Global Address List (GAL)

http://groups.google.com/groups?selm...g .google.com

http://groups.google.com/groups?selm...GP10.phx.gb l

http://groups.google.com/groups?selm...urocontrol.int

======================
From: David McRitchie )
Subject: Address Book - Outlook


View this article only
Newsgroups: microsoft.public.excel.programming
Date: 2004-08-20 19:07:06 PST


Hi Joseph,
See http://www.mvps.org/dmcritchie/excel/ofc2000.htm
see topic "Exporting Address Book to make modification in a Spreadsheet"

Basically you go to the address book, use File, Export, as other file,
select CSV file, open that file from Excel.

If you do make modifications to your address book, I would make a copy of
your
addressbook (.WAB) and store it offline.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

--
Regards,
Tom Ogilvy



"Praetorian Prefect" wrote in message
...
VBA code to extract the GAL into excel.