code to get list of names in Outlook Global Address List 1

[BitZero]

Can someone provide some me with VBA code that will read thru the names in my Outlook Global Address List and get names, phone numbers, and email. Thanks

 

[SkipVought]

hi,

You might want to post in forum707, since you're asking to coding help.

When you do, please post what code you are using so far.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

BTW, have you checked VBA Help in Outlook? 2007+ especially has some great topics and sample code.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[BitZero]

Skip

Thanks for the reply. I discovered (after much Google searching) that in Access you can do a Get External Data / Link Tables, search for files of type Exchange(), and select the Global Address List Address Book. That is much simpler than writing a routine to get the data.

 

[SkipVought]

Hey! Thanks for sharing a GREAT tip!

Have a little purple star!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}