There is no way to actually change Exchange entries in the GAL from EX to
SMTP. To get the SMTP address for a contact from the GAL you need to write
code. The code for versions of Outlook earlier than Outlook 2007 can't use
the Outlook object model, it would have to use CDO 1.21 or Extended MAPI
(C++ or Delphi only) or the Redemption library (www.dimastr.com/redemption).
For Outlook 2007 code you can use the PropertyAccessor object to access the
properties you need.

That won't change the addresses it will just return the SMTP address for the
EX address. After the code is run the GAL entries will still be the same.

There is sample code at www.cdolive.com/cdo5.htm for getting the SMTP
address using CDO 1.21, the Redemption Web site has samples for Redemption.

Programming questions should really be asked in
microsoft.public.outlook.program_vba.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"TLSebastian" wrote in message
...
I'd like to do the same thing. Is there a formula or macro you can write
in
Excel? And do I really have to post this to the Excel forum to get an
answer
if the problem originates with how Outlook handles Exchange information?

--
Trisha L. Sebastian
Research Assistant, Brown Harris Stevens


"Russ Valentine [MVP-Outlook]" wrote:

That is an Exchange question, not an Outlook question.