Home - Information Services - Get Help - How-to-Guides - Email & Calendar - Email Lists - Import an Email List into Excel

Import an Email List into Excel

1. Open Outlook 2016 on a MC computer.
2. Open the email list.
3. On the File tab, select Save As.
4. Click the Save as type down arrow and select Text Only.
   
   
5. Click Save.
6. Close the email list window.
7. Open Excel.
8. On the File tab, click Open.
9. Click Browse.
   
   
10. Click the down arrow across from the File name field and select All Files.
    
    
11. Select the text file.
12. Click Open.
13. On the Text Import Wizard window, make sure Delimited is selected.
    
    
14. Click Finish.
15. Delete the first 3 rows in the Excel file.
    
    
    
16. Enter column titles in blank row above the first entry.
    
    
    
17. Save the file.
18. Click Yes.
    
    
19. Click Save.