How do I Create a Contact Group (Personal Distribution List) from an Excel Spreadsheet?

From Excel

  1. Create the Excel Spreadsheet
    Excel Spreadsheet with names, addresses and e-mail addresses  
  2. Save the workbook as an Excel 97-2003 Workbook (from the File menu, click Save As.., select Excel 97-2003 Workbook from the "Save as type:" drop-down menu)
    Excel Spreadsheet Save As.. Excel 97-2007 document  
  3. Click Save
  4. Close Excel

In Outlook

  1. Open Outlook
  2. Select your Contacts folder
    Outlook Contacts Folder  
  3. Select the "Folder" tab
  4. Click on the "New Folder" button
    Outlook contacts create new folder window  
  5. In the "Create New Folder" dialog box enter a name for the folder in the "Name:" field
  6. Verify the "Folder contains:" field indicates "Contact Items"
  7. Click the OK button.
  8. A new folder is created under your Contacts folder.    
  9. From the Outlook File menu click "Open" and then "Import"
    Outlook Import   
  10. When the Import and Export Wizard opens, select "Import from another program or file" and click Next.
    Outlook Import and Export Wizard window   
  11. Scroll down the list and select Microsoft Excel 97-2003 and click Next.
    Import Export Wizard Import window  
  12. Click the Browse button.
    Import Wizard select file   
  13. Navigate to the Excel file to be imported
    File Browser window  
  14. Highlight the file to be imported and click the OK button.
  15. Under the Options section make sure that "Do not import duplicate items" is selected
    Import File Windows - do not import duplicates  
  16. Click Next
  17. Select the second contacts folder that now exists in your mailbox. This is the folder your data will be imported into.
    Import a File window - select second contact list  
  18. Click Next
  19. Click the "Map Custom Fields..." button
    Import a file window - Map Custom Fields   
  20. Follow the instructions noted at the top of dialog box "Drag the values from the source file on the left, and drop them on the appropriate destination field on the right. Drag the item from the right to the left to remove it from the field mapping."
    Map Fields window  
    Map Fields window  
    custom field mapping  
    Map Fields window  
  21. When all fields have been mapped click the OK button
  22. Click Finish. The new contacts list now includes the imported data from the Excel spreadsheet.
    populated second contact list  
  23. Select the new contact list and click the "New Contact Group" button under the "Home" tab
    New Contact Group button  
  24. The form to create a new Distribution List opens.
    New Contact Group window  
  25. In the "Name:" field enter a name for the contact group
  26. Click "Add Members" and then select "From Outlook Contacts"
    Distribution List select members  
  27. Navigate to the upper right corner and click the drop-down arrow.
  28. Select the name of the second contact list you created above.
    Select members  
  29. Click to select the first individual who should be in this contact group.
  30. Hold down the Shift key on your keyboard and while holding this key, click the last individual in the list.
  31. When all the names are highlighted click the "Members" button.
  32. Click the OK button. This adds the selected members to the distribution list.
    New poplulated contact group  
  33. Click Save and Close