How To Make A Distribution List In Outlook From Excel

Open the excel workbook that you will create a contact group from select the data and press ctrl c keys together to copy it.

How to make a distribution list in outlook from excel. When you want to send email to this team select the distribution list from the select namesdialog click to and then click on okbutton. To create outlook distribution list from an excel file please do as follows. For exporting distribution list contact group as csv file and import it to excel from outlook please do as follows. This method will guide you quickly create a contact group distribution list from excel data without applying the import and export wizard in outlook.

Select and copy all email addresses in the worksheet you need to create a distribution list based on. At the bottom of the select members dialog box in the members box right click and then click paste on the shortcut menu. Launch your outlook application and shift to the contacts view. Step 1 launch excel and open the spreadsheet with the email addresses to place into an outlook distribution list.

Please do as follows. Select the contact group you will export and click file save as. Click the microsoft office button and under create new outlook item click distribution list. In outlook shift to the contact view and open the contact folder containing the specified contact group.

Step 2 click the column or row header with the address list which highlights the.