VBA code to extract the GAL into excel.
T Tom Ogilvy Aug 21, 2004 #2 http://groups.google.com/[email protected] http://groups.google.com/[email protected] http://groups.google.com/[email protected] ====================== From: David McRitchie ([email protected]) Subject: Re: 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.
http://groups.google.com/[email protected] http://groups.google.com/[email protected] http://groups.google.com/[email protected] ====================== From: David McRitchie ([email protected]) Subject: Re: 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.
