Extract name of members from a distribution list

  • Thread starter Thread starter Rekha
  • Start date Start date
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.
 
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.
 
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.
Click to expand...
Click to expand...
 
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top