Email Questions  
     

Left Nav Register Home Forum Email Directory Email Marketing Search Today's Posts Mark Forums Read Right Nav

Left Container Right Container
 

Go Back   Email Questions Email Forums Email Newsletters


Email Newsletters Email newsletter discussions including best practices, deliverability, and reputation issues.

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

Email Newsletters


Reply
 
LinkBack Thread Tools Display Modes
Old Wednesday, November 19th, 2008   #1
Postmaster
 
popowich's Avatar
 
Join Date: Aug 2008
Location: Rochester, NY
Posts: 6,982
Thanks: 855
Thanked 635 Times in 597 Posts
Default How to import a mailing list from Microsoft Excel into Microsoft Outlook

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: 44587
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: 44051
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: 43980
Size:  12.5 KB

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

Register today to ask an email question in our email forums.
popowich is online now   Reply With Quote



Old Friday, May 29th, 2009   #2
New Email
 
Join Date: Nov 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: How to import a mailing list from Microsoft Excel into Microsoft Outlook

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.
Patrick is offline   Reply With Quote
Old Friday, May 29th, 2009   #3
Postmaster
 
popowich's Avatar
 
Join Date: Aug 2008
Location: Rochester, NY
Posts: 6,982
Thanks: 855
Thanked 635 Times in 597 Posts
Default Re: How to import a mailing list from Microsoft Excel into Microsoft Outlook

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
__________________

Register today to ask an email question in our email forums.
popowich is online now   Reply With Quote
Reply

Tags
export list, import, import list, mailing list, microsoft excel, microsoft outlook

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Outlook popowich Full Email Headers 4 Friday, January 31st, 2014 08:10 PM
How to access MSN Hotmail from Microsoft Outlook popowich Hotmail 0 Thursday, November 13th, 2008 10:19 PM
Microsoft Outlook Cached Mode popowich Microsoft Outlook 1 Thursday, October 2nd, 2008 10:13 PM
Microsoft Outlook Stuck Outbox popowich Microsoft Outlook 0 Tuesday, September 23rd, 2008 02:56 PM
Microsoft Outlook Raven Microsoft Outlook 6 Friday, August 15th, 2008 11:44 AM



All times are GMT -4. The time now is 10:39 PM.


vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.