How to Create a Distribution List From Microsoft Excel

By Tricia Goss

An email distribution list is simply a list of email addresses. Creating a distribution list for your email account allows you to send an email message to several people at one time without entering each individual email address. Having several email distribution lists makes it easy to send messages to different groups of people, such as everyone in a department or all the people in a certain class. You can use the easy to read format and sorting function of Microsoft Excel to create a distribution list for an Outlook or other email account.

Step 1

Start Microsoft Excel and open a blank worksheet. In cell "A1," type "First Name."

Step 2

Type "Last Name" into cell "B1" and "Email Address" into cell "C1."

Step 3

Type the first name, last name and email address of the first person in the distribution list into cells "A2," "B2" and "C2." Type the second person's information into row 3, and so on.

Step 4

Save the list in the desired location. If you are using Outlook, select "Excel 97-2003 Workbook" in the "Save as Type" box, as Outlook cannot import Excel 2007 lists.

Step 5

Import the distribution list using the email program's "Import and Export" menu (usually in the "File" menu). Import it using the "CSV" file option.