Extracting Global Address List (GAL)
VBA code to extract the GAL into excel.
|
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. |
All times are GMT +1. The time now is 05:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com