Exchange GAL - need SMTP

[PK]

Hi,

Danny Seager was kind enough to show me how to link an Access table to MS
Exchange to get Display Name, Alias, and a few more fields from our exchange
GAL by creating a linked table of type=exchange. One field I can not seem to
get is SMTP address (the one you get if you double click a recipient and go
to the E-Mail Addresses tab, listed as SMTP: xxxxxx). Does anyone know how I
can get this information for each member of the GAL? (PS: Outlook and
Access 2003)

tx

 

[Tom van Stiphout]

On Thu, 10 Jul 2008 05:02:01 -0700, PK <[email protected]>
wrote:

That's by design. See http://support.microsoft.com/kb/196873
You'll need a more powerful object library if you want all fields,
perhaps CDO.

-Tom.

 

[a a r o n . k e m p f]

You could iterate through the objects and properties using Outlook
Automation.

I'd go to www.freevbcode.com and look for Outlook and look at some of
that sourceCode for a reference.

It should be easy to loop through the properties bucket in order to
find the information you're looking for.

-Aaron

 

[PK]

Thank you both! I will take a look at FREEVBCode.com and go from there...