Extract name of members from a distribution list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rekha - 27 Sep 2004 16:28 GMT

Hi,

I am trying to export the names from a humongous
distribution list to excel. How can I do that?

Any suggestion is much appreciated.

Reply to this Message

Russ Valentine [MVP-Outlook] - 27 Sep 2004 17:19 GMT

There is no export function for a DL. You'd have to save it as a text file
and hope you can then import it to a Contacts Folder as an CSV or tab
delimited file.

Signature

Russ Valentine
[MVP-Outlook]

> Hi,
>
> I am trying to export the names from a humongous
> distribution list to excel. How can I do that?
>
> Any suggestion is much appreciated.

Reply to this Message

Sue Mosher [MVP-Outlook] - 27 Sep 2004 19:15 GMT

It's actually tab-delimited. Best to open in Notepad first to remove the DL
name and other non-data.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> There is no export function for a DL. You'd have to save it as a text file
> and hope you can then import it to a Contacts Folder as an CSV or tab
[quoted text clipped - 5 lines]
>>
>> Any suggestion is much appreciated.

Reply to this Message

Russ Valentine [MVP-Outlook] - 27 Sep 2004 20:48 GMT

Thanks, Sue. So saving a DL as a txt file creates a tab delimited file by
default? Good to know. Do you need to add a first row of field names to
import it?

Signature

Russ Valentine
[MVP-Outlook]

> It's actually tab-delimited. Best to open in Notepad first to remove the
> DL name and other non-data.
[quoted text clipped - 8 lines]
>>>
>>> Any suggestion is much appreciated.

Reply to this Message