Global Address book user properties lookup module

[sparkbyte]

Has anyone seen a module to lookup user properties in the Outlook Global Address book?

Thanks

John Fuhrman
faq329-6766
thread329-1334328
thread329-1424438

 

[joebb3]

LOL! I was just doing the same thing... Found THIS on MSDN...

If objSession Is Nothing Then
    MsgBox "Must first create MAPI session and log on"
    Exit Function
End If
Set objRecipColl = objSession.AddressBook(Title:="Select Attendees", _
                      forceResolution:=True, _
                      recipLists:=3, _
                      toLabel:="&Very Important People", _
                      ccLabel:="&Fairly Important People", _
                      bccLabel:="&Secret Important People")
' "recipients:=" parameter not used in preceding call
MsgBox "Name of first recipient = " & objRecipColl.Item(1).NAME
' could be objRecipColl(1) since Item and Name are default properties
Exit Function

End Function

Problems:
I can't figure out how to initiate the MAPI object.
and
you have to add the first line of the function, ex: Function AddressBoxPop()

Can anyone help get this going? It would be a boon to my db as well!