Extract name of members from a distribution list

R

Rekha

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.
 
R

Russ Valentine [MVP-Outlook]

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.
 
S

Sue Mosher [MVP-Outlook]

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

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Russ Valentine said:
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.
--
Russ Valentine
[MVP-Outlook]
Rekha said:
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.
 
R

Russ Valentine [MVP-Outlook]

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?
--
Russ Valentine
[MVP-Outlook]
Sue Mosher said:
It's actually tab-delimited. Best to open in Notepad first to remove the
DL name and other non-data.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Russ Valentine said:
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.
--
Russ Valentine
[MVP-Outlook]
Rekha said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top