Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Extracting Global Address List (GAL)

VBA code to extract the GAL into excel.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Global Address List after clicking E-mail button in Excel 2003 elance Excel Discussion (Misc queries) 0 October 8th 09 02:34 PM
Global update hyperlink address j Setting up and Configuration of Excel 1 February 7th 07 04:58 AM
Extracting out of a emai address string harpscardiff Excel Discussion (Misc queries) 6 June 12th 06 09:19 AM
Extracting # numbers from address KH Excel Discussion (Misc queries) 2 August 4th 05 05:45 PM
information From Global Address Book into list box. ELGIN Excel Programming 0 July 30th 04 05:05 AM


All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"