GAL in combobox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
"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
 
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!
 
Back
Top