Export members of a Distribution List

[sirlance]

Hello All,
I have a full AD with EX 2K environment. I have the need to export memebers of a distibution list to an excel file. EX 5.5 Admin had that functionality, but I'm not sure if 2K does. Can anybody help?

Thanks

 

[jbud]

I am under the impression that the only way to do so is via 3rd party app or ADSI scripting. Others may have different answers. If you've done any scripting, it's easy to iterate the Members property of the List object.

 

[sirlance]

Thanks. Done some basic scripting, but not enough to do any good.

Anyone else??

 

[xmsre]

ldifde or csvde

 

[sunespace]

If you only want the display names of the members you can use Outlook.

Create a new mail, click the "To..." button, browse your DL, mark the DL, right click and choose "Properties".

Mark all DL members and click the "To" button. Say "Yes" to the pop-up question. Close the "Properties" window, and click "OK" in the Select Name window.

Now you have the display names of the DL members in the address box. Just mark and copy them into Notepad, Excel etc.

 

[sirlance]

That worked perfectly. Thanks!!