How to Export a Distribution List in Outlook to Excel
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.
And replace the semicolon with new lines command (^p) Click on the "Replace All" button. This action will make a list.....
Select all and copy this list.
Open Excel and select the "Paste" button
In Excel, click on the "Data" menu/tab and select "Text to Column"
This will bring up the "Convert Text to Columns Wizard" Choose "Delimited" and click on the "Next" button.
Select "Other" and put the "" symbol and on the "Replace" field put nothing. Click on the "Replace All" button.
Check you results and you will see that Column A has the user names and column B contains just the email addresses.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- convert text to columns wilmington university
- convert text to a table
- how to export a distribution list in outlook to excel
- featurizing text converting text into predictors for
- an introduction to version 12 planning engineer est
- outreg help pages kellogg school of management
- microsoft excel green belt training read only ohio
- ultimate suite for excel comprehensive set of time saving
- working with tables libreoffice
- 102 useful excel formulas cheat sheet pdf free download
Related searches
- how to export excel to pdf
- how to reverse a list in python
- how to create a list in java
- how to export excel to word
- how to multiply a list in python
- how to create a list in python
- how to export excel file
- how to split a list in python
- how to export contacts from outlook online
- how to export data from excel spreadsheet
- how to export a file to excel
- how to define a list in java