GAL in combobox
 

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

GAL in combobox
 

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

"joe schmo" wrote in message
...
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

GAL in combobox
 

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

"Dmitry Streblechenko" wrote:

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

"joe schmo" wrote in message
...
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

GAL in combobox
 

"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

"joe schmo" wrote in message
...
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

"Dmitry Streblechenko" wrote:

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

"joe schmo" wrote in message
...
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

GAL in combobox
 

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!


"Dmitry Streblechenko" wrote:

"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

"joe schmo" wrote in message
...
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

"Dmitry Streblechenko" wrote:

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

"joe schmo" wrote in message
...
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

GAL in combobox
 

Call AddItem instead of setting the Text property.

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

"joe schmo" wrote in message
...
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!


"Dmitry Streblechenko" wrote:

"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

"joe schmo" wrote in message
...
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

"Dmitry Streblechenko" wrote:

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

"joe schmo" wrote in message
...
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