|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
June 22nd 06, 12:02 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Extract email addresses from Distribution LIst in Global Address List
Thanks for the direction...after a lot of fumbling..this is what we came up
with... Public Function ADLIST(DistName As String) As String Dim strValue As Variant, EmailMe As String Set getDn = GetObject("LDAP://CN=" & DistName & ",OU=Distribution Groups,DC=gunnallen,DC=com") strAllValues = getDn.getex("member") For Each strValue In strAllValues Set getDn2 = GetObject("LDAP://" & strValue) strEmail = getDn2.getex("mail") EmailMe = EmailMe & IIf(Len(EmailMe) = 0, "", ", ") & strEmail(0) Next Set strAllValues = Nothing Set strEmail = Nothing ADLIST = EmailMe End Function Sue Mosher [MVP-Outlook] wrote: CDO for Windows (which is what CDO.Message) implies cannot help you with this. Either use ADSI methods or CDO 1.21 or Redemption. The code sample at http://www.cdolive.com/cdo5.htm#DeleteDLMember shows one way of working with GAL DL members with CDO 1.21. Greetings, I am using CDO.Message to send email messages from my access application. I [quoted text clipped - 12 lines] much thanks Teresa -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...g-vba/200606/1 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Adding a set of email addresses to a distribution list | chermesh | Outlook - Using Contacts | 2 | June 4th 06 07:35 AM |
| Why do names in my distribution list revert to email addresses? | Laurey | Outlook - Using Contacts | 1 | March 10th 06 10:18 AM |
| create new distribution list in global address lists in exchange | tim | Outlook - Using Contacts | 1 | February 6th 06 09:52 PM |
| How do I find the number of email addresses in a distribution list | Shockle | Outlook - Using Contacts | 1 | January 30th 06 10:13 PM |
| how do I print a distribution list from a global address book? | Sue Mosher [MVP-Outlook] | Outlook - Using Contacts | 0 | January 18th 06 05:11 PM |
Hybrid Mode
