How to Export Outlook Distribution List to Excel
How to export Outlook Distribution List to .csv file format
Step 1: Save Distribution List as Text file
Open your Outlook, click Distribution List you try to export. And click File, Save As... On the Save As window, select Text Only (*.txt) in the Save As Type drop down on the bottom. Name your file, for example test01.txt, and then save it on your local machine.
Step 2: Open the saved Text file in Microsoft Excel
Launch your Microsoft Excel application, and Open the saved file above. When you do opening, just make sure the Files of Type should be All Files, or Text Files. When you select the test01.txt from previous step, you will be automatically redirected to Text Import Wizard like the below.
You can keep the default value, but on this Step 1 of 3 screen, please make sure you select the right Start import at row:. Since the default value of 1 is apparently not what you want with something like "Distribution List Name: ...." occupy at least 4 rows. So you can find the first row with email address and put the row number (on the left) in the Start import at row: number field.
When you continue with "Next" clicking, you just review the screen and make sure everything is what you want, and click Finish in the last step. And your file will be opened in Excel successfully.
Step 3: Save Excel file as CSV file
In Excel, click File, Save As and on the Save As window, make sure you change the Save as Type as CSV like the screen below.
Name your file, for example test01.csv and you are done with the exporting. Next you need to do is to repeat on other distribution list. Good luck! Disclaimer: all steps and screen shots above are based on the version of Microsoft Outlook 2003 and Microsoft Excel 2003.
................
................
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
- powershell 2 0 one cmdlet at a time
- import excel — import and export excel files
- powershell for projectwise how does it work
- pnp powershell admin scripts export list data
- importing and exporting net2 user data
- how to export outlook distribution list to excel
- powershell cheat sheet import export convert
- ad using powershell nmap and excel for inventory
Related searches
- how to export pdf to excel
- how to export excel to pdf
- how to export dataset from r
- how to export excel to word
- how to export excel file
- how to export active directory
- how to export contacts from outlook online
- how to export word to excel
- how to export data from excel spreadsheet
- how to export a file to excel
- how to export on excel
- how to export notepad to excel