Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Tim
Private Sub RetrieveOutlookList()
Dim ol As Object
Set ol = CreateObject("Outlook.Application")
Dim aPAB() As Variant
Dim adl As Outlook.AddressList
Dim e As Outlook.AddressEntry
Dim i As Integer
ReDim aPAB(1000) 'this Dim can be improved, depending on
how many names are in the Address Book.
Set nsMapi = ol.GetNamespace("Mapi")
Set adl = nsMapi.AddressLists("Personal Address Book")
For Each e In adl.AddressEntries
i = i + 1
ComboBox1.AddItem (e.Name) 'adds entry to comboBox1
Next
ReDim aPAB(i - 1)
End Sub
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!