Saving a distribution list to excel

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

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

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

Sue Mosher [MVP]

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

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.
 

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