> Folks,

> I'm referencing the Outlook Object Model from Excel, and would like
to
> examine the GAL and add each of the Distribution Lists into an array
of some
> discription, to be later added into a drop down box.

> Does anybody have any ideas how or if this can be done.

> Thanks in advance,
> Stef

> Use AddressLists("Global Address List") to get the GAL as an
> AddressList. Then get the AddressEntries collection for that list.
> Then check for the DisplayType property of each AddressEntry object.
> For DL's in the GAL it would be olDistList (1)

> --
> Ken Slovak
> [MVP - Outlook]
> Lead Author, Professional Outlook 2000 Programming, Wrox Press
> Co-author of "Programming Microsoft Outlook 2000", Chapters 8-13,
> Appendices, Sams

> > Folks,

> > I'm referencing the Outlook Object Model from Excel, and would like
> to
> > examine the GAL and add each of the Distribution Lists into an array
> of some
> > discription, to be later added into a drop down box.

> > Does anybody have any ideas how or if this can be done.

> > Thanks in advance,
> > Stef