PDA

View Full Version : Grabbing Owner info on a "Global Address List" Distribution List



blu3dud3
04-27-2007, 09:56 AM
Hello,

I have been given a spreadsheet that has a list of all of the Global Address List distribution lists that haven't been used in the past 365 days.

My job is to create a spreadsheet that has the name of the owner if there is one or a name of a member of that group.

Dim xAddrList As MAPI.AddressList
Dim xSession As MAPI.Session
Dim xAddrEntry As MAPI.AddressEntry
Set xSession = New MAPI.Session

xSession.Logon , , False, False
Set xAddrList = xSession.AddressLists("Global Address List")

xAddrList.AddressEntries.Item(xName.clsValue).Members


I am able to grab a list of the members from this class, where xName.clsValue is a personal class that I made that contains the name of the DL that I grabed from the spreadsheet.

This part works fine for me, but how do I grab the name of the owner of the GAL Distribution List?

cdolive.com/cdo10.html lists the following

PR_EMS_AB_OWNER = &H800C001E ' Exchange server distribution list owner as distinguish name

It looks promissing, but I can't seem to figure out how to grab this field.

Any suggestions?

-Troy Treuber