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
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