GAL in combobox

J

joe schmo

Is there any way to make a combobox and list the users from the Global
address list? Using exchange 2003, outlook2003. Have searched a lot but
come up empty. many thanks
 
D

Dmitry Streblechenko

set GAL = Application.Session.AddressLists("Global Address List")
for each AE in GAL.AddressEntries
Debug.Print AE.Name
next

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
 
J

joe schmo

I may need a bit more. This doesn't seem to work in an Outlook form. I put
this code in the Form script editor and changed "global address list" to
combobox3, but it doesn't populate. Do I need to specify the exchange
server, or am I missing something? thanks for any more help
 
D

Dmitry Streblechenko

"Global Address List" is the name of the address list (the one you see in
the address Book), not the name of the control.
Replace the Debug.Print line with the code that explicitly populates your
combo box items.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
 
J

joe schmo

Thanks Dmitry, it worked with your help!
the only problem now is instead of Debug.print I put in combobox3.text=AE.Name
Now the only name that shows is the last name in the alphabet. Any way to
list them all in the drop down? thanks a alot!
 
Top