Saving a distribution list to excel

  • Thread starter Thread starter Bruce Johnson
  • Start date Start date
B

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??
 
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.
 
Alternately, open the .txt file in Notepad, remove the first few
non-delimited lines and save it as a .csv file.
Click to expand...

As far as I can tell, you can't save a file as CSV from within Notepad.
 
Sure you can, unless Windows is set to hide file extensions. Just save it
with a file name of something.csv.
 
Sure you can, unless Windows is set to hide file extensions. Just save it
with a file name of something.csv.
Click to expand...

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.
 
Back
Top