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

Discussion in 'Email Newsletters' started by popowich, Nov 19, 2008.

  1. popowich

    popowich EQ Forum Admin Staff Member

    Joined:
    Aug 12, 2008
    Messages:
    7,951
    Likes Received:
    57
    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:
    Excel - Save as 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:
    Microsoft Outlook - Contacts.JPG

    • Go to the File menu, select New, select Folder
    Microsoft Outlook - File New Folder.JPG

    • Create the New Folder with the name of the Mailing List
    Microsoft Outlook - Create New Folder.JPG

    • Go back to the File menu and select Import and Export
    Microsoft Outlook - Import Export.JPG

    • Select Import from another file or program, then click Next
    Microsoft Outlook - Import Export Wizard.JPG

    • Choose Comma Separated Values (Windows) and click Next
    Microsoft Outlook - Import a File.JPG

    • Select Allow Duplicates to be Created and Browse to your CSV file
    Microsoft Outlook - Import a File - Browse.JPG

    • Import the CSV file to the Mailing List Folder that you created earlier
    Microsoft Outlook - Select Mailing List Folder.JPG

    • Click the checkbox, and then select Map Custom Fields
    Microsoft Outlook - Map Custom Fields.JPG

    • Drag the information on the left to the corresponding fields on the right
    Microsoft Outlook - Map Custom Fields - Step 2.JPG

    [LIST]
    [*]Click [B]OK[/B] when you are done mapping the fields, and then [B]Finish
    [/B]
    [*]Go back to your Contacts view.
    [*]Go to the [B]File menu[/B], select [B]New[/B], then select [B]Distribution List[/B]
    [/LIST]
    [CENTER][ATTACH]145.vB[/ATTACH][/CENTER]

    [LIST]
    [*]Create a name for the list, then click the [B]Select Members[/B] button
    [*]Select the Mailing List folder you created earlier:
    [/LIST]
    [CENTER][ATTACH]141.vB[/ATTACH]
    [LEFT]
    [LIST]
    [*]To quickly select all of the addresses click the top one, hold down the shift key, and then click the bottom address.
    [*]Click [B]OK[/B] when you are done selecting the addresses
    [*]Click Save and Close
    [/LIST]
    [CENTER][ATTACH]142.vB[/ATTACH]
    [LEFT]
    [LIST]
    [*]To send to the list start a new e-mail as your normally would, click the [B]To[/B] button, [B]select the Distribution List[/B] from the drop down menu, and click [B]OK[/B]
    [/LIST]
    [CENTER][ATTACH]143.vB[/ATTACH]
    [LEFT]
    [LIST]
    [*]Compose the message and click [B]Send[/B] when done!
    [/LIST]
    [CENTER][ATTACH]144.vB[/ATTACH]

    [LEFT]If you have any questions about Microsoft Outlook please create a new thread in our [URL="http://www.emailquestions.com/forumdisplay.php?f=15"]Microsoft Outlook Support Forum[/URL].[/LEFT]
    [/CENTER]
    [/LEFT]
    [/CENTER]
    [/LEFT]
    [/CENTER]
    [/LEFT]
    [/CENTER]
     
  2. Patrick

    Patrick New Email

    Joined:
    Nov 19, 2008
    Messages:
    3
    Likes Received:
    0
    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.
     

  3. popowich

    popowich EQ Forum Admin Staff Member

    Joined:
    Aug 12, 2008
    Messages:
    7,951
    Likes Received:
    57
    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
     

Want to reply or ask your own question?

It only takes a minute to sign up (and it's free!). Click the orange sign up button to choose a username and then you can ask your own questions on the forum.
Loading...

Share This Page