HOW TO EXPORT A DISTRIBUTION LIST IN OUTLOOK TO EXCEL.
In Outlook, start a new message.
On the TO field, put the any DL. In the picture below, I am using PATH-USERS
Click on “+” to reveal the contents of the DL. You will get this WARNING, click on the OK button
Highlight and copy all names and paste them in MS Word.
In Word, select all the text you inserted and use the “Replace” function to make a list.