Click here to Skip to main content
15,881,600 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
this works with the "full name" but not an alais
VB
Function userDetail(theAlias As String) As String

Dim olkDL As Outlook.DistListItem
Dim olkEntry As Outlook.Recipient
Dim olkContact As Outlook.ContactItem
Dim intCount As Integer
Dim strAddress As String
Dim strName As String
Dim oApp As Outlook.Application
Dim oNS As Outlook.Namespace
Dim oALs As Outlook.AddressLists
Dim oGal As Outlook.AddressList
Dim oEntries As Outlook.AddressEntries
Dim oEntry As Outlook.AddressEntry
Dim oAlias As Outlook.ContactItem

On Error GoTo outlookClosed

Set oApp = Outlook.Application
On Error GoTo 0

Set oNS = oApp.Session ' Get the MAPI namespace.
Set oALs = oNS.AddressLists ' Get the Global Address List.
Set oGal = oALs.Item("Global Address List") ' Get all the entries.

Alias = LCase(Trim(theAlias))

Set oEntries = oGal.AddressEntries
Set oEntry = oEntries(Alias)

'********************************************
'OUTPUT
'********************************************

'userDetail = oEntry.GetExchangeUser.JobTitle
'userDetail = oEntry.GetExchangeUser.Alias
'userDetail = oEntry.GetExchangeUser.Department
'userDetail = oEntry.GetExchangeUser.OfficeLocation
'userDetail = oEntry.GetExchangeUser.StreetAddress
'userDetail = oEntry.GetExchangeUser.Address
'userDetail = oEntry.GetExchangeUser.City
'userDetail = oEntry.GetExchangeUser.StateOrProvince
'userDetail = oEntry.GetExchangeUser.MobileTelephoneNumber

'userDetail = oEntry.GetExchangeUser.MobileTelephoneNumber
userDetail = oEntry.GetExchangeUser.OfficeLocation

'********************************************
'OUTPUT
'********************************************

Exit Function

outlookClosed:
userDetail = False

Exit Function

End Function
Posted
Updated 20-Mar-12 12:35pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900