Creating a Group Contact List
Use a contact group (formerly called a “distribution list”) to send an email to multiple people—a project team, a committee, or even just a group of friends—without having to add each name to the To, Cc, or Bcc line individually.
In Excel:
Select the addresses from the column containing the email addresses. Optionally, if you have a column that includes the Name, you can also select that column.
Make sure you do not select the row containing the header information.
Press CTRL+C to copy the selected cells.
In Outlook:
1. On the Navigation bar, click People
Note: You can find People in one of two places on the Navigation bar.
Or
2. Under My Contacts, select the folder where you want to save the contact group.
3. One the Ribbon, select “New Contact Group” and give the group a name.
4. Open the “Add Members” dialog box and select “From Outlook Contacts”
5. Instead of selecting your members from your list of contacts, click in the text field next to the Members button and press CTRL+V to past the copied content from Excel. If done correctly, each address will be listed on its own line. Press OK to close the Select Members dialog box.
For additional information and tips, please see Contacts and tasks
For information about contact groups in for Mac, see Create a contact group in Outlook for Mac.