Saving a distribution list to excel

[Bruce Johnson]

I have a DL called employees. When I address a new email, I can expand the
DL to show all the employee names. I want to save to excel with name, email
address.

When I open the DL in contacts, I just see employees as the only member in
the DL.

How can I extract the names and addresses??

 

[Sue Mosher [MVP]]

Save the DL as a .txt file. It will be a tab-delimited file with a few
non-deliminted lines at the top. You should then be able to use Excel's Get
External Data command to insert that data into a spreadsheet.

Alternately, open the .txt file in Notepad, remove the first few
non-delimited lines and save it as a .csv file.

 

[Brian Tillman [MVP - Outlook]]

Alternately, open the .txt file in Notepad, remove the first few
non-delimited lines and save it as a .csv file.

As far as I can tell, you can't save a file as CSV from within Notepad.

 

[Sue Mosher [MVP]]

Sure you can, unless Windows is set to hide file extensions. Just save it
with a file name of something.csv.

 

[Brian Tillman [MVP - Outlook]]

Sure you can, unless Windows is set to hide file extensions. Just save it
with a file name of something.csv.

But when you save a DL in Outlook, it gets saved as a tab-separated values
file and there's no way in Notepad to convert that to a comma-separated values
file without replacing the tabs with commas manually.