Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Distribution List (2003)

    I need to be able to get e-mail addresses out of a distribution list. We have 200 members in the list. I do not want look up their e-mail addresses. Is there a way to get hold of the members of the list with their e-mail addresses that any of you know of?

    Thanks in advance,

    itconc

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Distribution List (2003)

    I'm not positive of what you are asking. If you open a distribution list, from the File menu you can move or copy it to another folder, or you can export it to a file. You can also move or copy individual entries in the list using the File menu.
    Legare Coleman

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Distribution List (2003)

    I think you could through VBA code. <post#=323204>post 323204</post#> & <post#=349004>post 349004</post#> have some related code, though not exactly what you might want. When you extract the addresses where do you want to put them?
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Distribution List (2003)

    Here's some starter code for an open distribution list:

    Sub EMailAddressFromDistList()
    Dim lngC As Long
    Dim strAddrEntry As String
    With Outlook.Application.ActiveInspector.CurrentItem
    If .Class = olDistributionList Then
    For lngC = 1 To .MemberCount
    strAddrEntry = strAddrEntry & .GetMember(lngC).Address & vbLf
    Next lngC
    MsgBox strAddrEntry
    Else
    MsgBox "Selected item is not a Distribution List"
    End If
    End With
    End Sub
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Distribution List (2003)

    Thanks,
    I can do a file save as with the distribution list I created. What about one that is in our global address list. When I open it, a little popup with the names and all the details comes up. No file menu is available.
    itconc

  6. #6
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Distribution List (2003)

    Thanks,
    What I want to do is end up with a list of names in that list and their email addresses. If I own the Distr. List I can export it but not if it is in the GAL.

    itconc

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Distribution List (2003)

    Assuming you have an appropriate business reason, it will be easier to ask your Server Admin; they have tools for that stuff.

    I looked quickly at the Outlook Object Model, and the Access method of opening the GAL, and I didn't see where the individual entry is linked to a DL, so I don't immediately see how to do it by VBA code or Access Query.

    And thank you, and Legare - I didn't realize that a Contact Item DL could be saved as a Text File, I had never investigated it.
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Distribution List (2003)

    I don't know any way to get it from a GAL distribution list other than have the system admin export for you.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •