Distribution List (2003)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

I think you could through VBA code. post 323204 & post 349004 have some related code, though not exactly what you might want. When you extract the addresses where do you want to put them?

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote