Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
HI,
I am new in this. I have to get the Information from the GAL into the listbox. First i would need to find the User name from the GAL. then which i would need to get the information(phone number, address, alias, department) of the selected name output into the listbox of the UserForm. I manage only to get the userName into the combolist. But Can anyone how can i use the selected name to extract out the details of the selected name from the combolist? Public Sub Import_Contacts() Set olApp = New Outlook.Application Set olNamespace = olApp.GetNamespace("MAPI") Set olAddressList = olNamespace.AddressLists("Global Address List") narCNT = olAddressList.AddressEntries.count redim strarray(narCNT+1) i=0 For Each olAB In olAddressList.AddressEntries STRArray(i)=trim(olAB.NAme) comboList1.addItem (strArray(i)) i=i+1 do events next olAB set olApp = nothing End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Global Address List after clicking E-mail button in Excel 2003 | Excel Discussion (Misc queries) | |||
excel list of names, addresses and email to address book/contact list??? | Excel Discussion (Misc queries) | |||
Global update hyperlink address | Setting up and Configuration of Excel | |||
Automating Address Information based on selecting data via a validation list | Excel Worksheet Functions | |||
How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) |