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

[EQ Admin]

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:

• 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:

• Go to the File menu, select New, select Folder

• Create the New Folder with the name of the Mailing List

• Go back to the File menu and select Import and Export

• Select Import from another file or program, then click Next

• Choose Comma Separated Values (Windows) and click Next

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

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

• Click the checkbox, and then select Map Custom Fields

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

• 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:

• 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

• 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

• Compose the message and click Send when done!

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

 

[Patrick]

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.

 

[EQ Admin]

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