How to import a mailing list from Microsoft Excel into Microsoft Outlook

popowich · Wednesday, November 19th, 2008

Hello,

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:

How to import a mailing list from Microsoft Excel into Microsoft Outlook-excel-save-csf-file.jpg

If Microsoft Excel is running then save all files and close Excel

Go to the Contacts view in Outlook. I click this button in the bottom right:

Name: Microsoft Outlook - Contacts.JPG
Views: 2190
Size: 6.7 KB

Go to the File menu, select New, select Folder

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-file-new-folder.jpg

Create the New Folder with the name of the Mailing List

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-create-new-folder.jpg

Go back to the File menu and select Import and Export

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-import-export.jpg

Select Import from another file or program, then click Next

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-import-export-wizard.jpg

Choose Comma Separated Values (Windows) and click Next

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-import-file.jpg

Select Allow Duplicates to be Created and Browse to your CSV file

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-import-file-browse.jpg

Import the CSV file to the Mailing List Folder that you created earlier

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-select-mailing-list-folder.jpg

Click the checkbox, and then select Map Custom Fields

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-map-custom-fields.jpg

Drag the information on the left to the corresponding fields on the right

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-map-custom-fields-step-2.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

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-new-distribution-list.jpg

Create a name for the list, then click the Select Members button
Select the Mailing List folder you created earlier:

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-send-mailing-list.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

Name: Microsoft Outlook - Save and Close.JPG
Views: 2146
Size: 12.5 KB

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

How to import a mailing list from Microsoft Excel into Microsoft Outlook-microsoft-outlook-send-list.jpg

Compose the message and click Send when done!

Name: Microsoft Outlook - Send Email.JPG
Views: 2138
Size: 12.5 KB

If you have any questions about Microsoft Outlook please create a new thread in our Microsoft Outlook Support Forum.

Patrick · Friday, May 29th, 2009

Once I have the names in the distribution list and send out the E-mail will the E-mail go out one at a time and is there a limit to how many in my distribution list.

popowich · Friday, May 29th, 2009

Hi Patrick,

I don't have access to an Outlook at the moment but I believe they send separately.

The limits for number of connections and recipients per email vary by ISP.

I see that Bell South limits by size (10MB) and that they might try to bill you $5 per spam incident, but I do not see any other limits publicly posted about their service.

If you are using another providers SMTP outgoing mail servers I can try to help you look up their limits.

-Raymond

How to import a mailing list from Microsoft Excel into Microsoft Outlook

Mailing Lists