Hello,
To import a mailing list from Microsoft Excel into Microsoft Outlook please follow these steps:
![Microsoft Outlook - Contacts.JPG Microsoft Outlook - Contacts.JPG](https://www.emailquestions.com/data/attachments/0/107-ce0df1e09836355c9250a0c6cba30ffe.jpg)
![Microsoft Outlook - File New Folder.JPG Microsoft Outlook - File New Folder.JPG](https://www.emailquestions.com/data/attachments/0/108-e837482a9932873008e9d9c6e5a2a4c6.jpg)
![Microsoft Outlook - Create New Folder.JPG Microsoft Outlook - Create New Folder.JPG](https://www.emailquestions.com/data/attachments/0/109-ff76b3024797d5f09d7572291bba7854.jpg)
![Microsoft Outlook - Import Export.JPG Microsoft Outlook - Import Export.JPG](https://www.emailquestions.com/data/attachments/0/110-7a2db43e329230d77253205453ce8575.jpg)
![Microsoft Outlook - Import Export Wizard.JPG Microsoft Outlook - Import Export Wizard.JPG](https://www.emailquestions.com/data/attachments/0/111-b4968fad322fca1139e4925ed8793664.jpg)
![Microsoft Outlook - Import a File.JPG Microsoft Outlook - Import a File.JPG](https://www.emailquestions.com/data/attachments/0/112-c76ea1f49bb37f0aaef728e1e3bb1fdf.jpg)
![Microsoft Outlook - Import a File - Browse.JPG Microsoft Outlook - Import a File - Browse.JPG](https://www.emailquestions.com/data/attachments/0/113-6a5a900d2225ecd63c9fa9047963fe21.jpg)
![Microsoft Outlook - Select Mailing List Folder.JPG Microsoft Outlook - Select Mailing List Folder.JPG](https://www.emailquestions.com/data/attachments/0/114-c4c63cc0b29672ea93076f48831a789b.jpg)
![Microsoft Outlook - Map Custom Fields.JPG Microsoft Outlook - Map Custom Fields.JPG](https://www.emailquestions.com/data/attachments/0/115-ea8726ba99014a5d27425576ba4eb5e5.jpg)
![Microsoft Outlook - Map Custom Fields - Step 2.JPG Microsoft Outlook - Map Custom Fields - Step 2.JPG](https://www.emailquestions.com/data/attachments/0/117-f7bb7f8da9aaafec08c6d094800b194d.jpg)
![Microsoft Outlook - Send to Mailing List.JPG Microsoft Outlook - Send to Mailing List.JPG](https://www.emailquestions.com/data/attachments/0/118-c9e14f98273e47c4cc28f17e53abecd8.jpg)
![Microsoft Outlook - Save and Close.JPG Microsoft Outlook - Save and Close.JPG](https://www.emailquestions.com/data/attachments/0/119-cf6d21b81d7f954fcb59b63016c40793.jpg)
![Microsoft Outlook - Send to List.JPG Microsoft Outlook - Send to List.JPG](https://www.emailquestions.com/data/attachments/0/120-a04c6c6fbfb266b139270c0d438dc419.jpg)
![Microsoft Outlook - Send Email.JPG Microsoft Outlook - Send Email.JPG](https://www.emailquestions.com/data/attachments/0/121-b4109eff650dbe0c802c72b87eb1b0dd.jpg)
To import a mailing list from Microsoft Excel into Microsoft Outlook please follow these steps:
- First, if the file is not already in CSV format, save save file as a CSV:
- Go to the Contacts view in Outlook. I click this button in the bottom right:
![Microsoft Outlook - Contacts.JPG Microsoft Outlook - Contacts.JPG](https://www.emailquestions.com/data/attachments/0/107-ce0df1e09836355c9250a0c6cba30ffe.jpg)
- Go to the File menu, select New, select Folder
![Microsoft Outlook - File New Folder.JPG Microsoft Outlook - File New Folder.JPG](https://www.emailquestions.com/data/attachments/0/108-e837482a9932873008e9d9c6e5a2a4c6.jpg)
- Create the New Folder with the name of the Mailing List
![Microsoft Outlook - Create New Folder.JPG Microsoft Outlook - Create New Folder.JPG](https://www.emailquestions.com/data/attachments/0/109-ff76b3024797d5f09d7572291bba7854.jpg)
- Go back to the File menu and select Import and Export
![Microsoft Outlook - Import Export.JPG Microsoft Outlook - Import Export.JPG](https://www.emailquestions.com/data/attachments/0/110-7a2db43e329230d77253205453ce8575.jpg)
- Select Import from another file or program, then click Next
![Microsoft Outlook - Import Export Wizard.JPG Microsoft Outlook - Import Export Wizard.JPG](https://www.emailquestions.com/data/attachments/0/111-b4968fad322fca1139e4925ed8793664.jpg)
- Choose Comma Separated Values (Windows) and click Next
![Microsoft Outlook - Import a File.JPG Microsoft Outlook - Import a File.JPG](https://www.emailquestions.com/data/attachments/0/112-c76ea1f49bb37f0aaef728e1e3bb1fdf.jpg)
- Select Allow Duplicates to be Created and Browse to your CSV file
![Microsoft Outlook - Import a File - Browse.JPG Microsoft Outlook - Import a File - Browse.JPG](https://www.emailquestions.com/data/attachments/0/113-6a5a900d2225ecd63c9fa9047963fe21.jpg)
- Import the CSV file to the Mailing List Folder that you created earlier
![Microsoft Outlook - Select Mailing List Folder.JPG Microsoft Outlook - Select Mailing List Folder.JPG](https://www.emailquestions.com/data/attachments/0/114-c4c63cc0b29672ea93076f48831a789b.jpg)
- Click the checkbox, and then select Map Custom Fields
![Microsoft Outlook - Map Custom Fields.JPG Microsoft Outlook - Map Custom Fields.JPG](https://www.emailquestions.com/data/attachments/0/115-ea8726ba99014a5d27425576ba4eb5e5.jpg)
- Drag the information on the left to the corresponding fields on the right
![Microsoft Outlook - Map Custom Fields - Step 2.JPG Microsoft Outlook - Map Custom Fields - Step 2.JPG](https://www.emailquestions.com/data/attachments/0/117-f7bb7f8da9aaafec08c6d094800b194d.jpg)
- Click OK when you are done mapping the fields, and then Finish
- Go back to your Contacts view.
- Go to the File menu, select New, then select Distribution List
- Create a name for the list, then click the Select Members button
- Select the Mailing List folder you created earlier:
![Microsoft Outlook - Send to Mailing List.JPG Microsoft Outlook - Send to Mailing List.JPG](https://www.emailquestions.com/data/attachments/0/118-c9e14f98273e47c4cc28f17e53abecd8.jpg)
- To quickly select all of the addresses click the top one, hold down the shift key, and then click the bottom address.
- Click OK when you are done selecting the addresses
- Click Save and Close
![Microsoft Outlook - Save and Close.JPG Microsoft Outlook - Save and Close.JPG](https://www.emailquestions.com/data/attachments/0/119-cf6d21b81d7f954fcb59b63016c40793.jpg)
- To send to the list start a new e-mail as your normally would, click the To button, select the Distribution List from the drop down menu, and click OK
![Microsoft Outlook - Send to List.JPG Microsoft Outlook - Send to List.JPG](https://www.emailquestions.com/data/attachments/0/120-a04c6c6fbfb266b139270c0d438dc419.jpg)
- Compose the message and click Send when done!
![Microsoft Outlook - Send Email.JPG Microsoft Outlook - Send Email.JPG](https://www.emailquestions.com/data/attachments/0/121-b4109eff650dbe0c802c72b87eb1b0dd.jpg)
If you have any questions about Microsoft Outlook please create a new thread in our Microsoft Outlook Support Forum.