DISCOVER
×

How to Add Bulk Email Addresses to Contacts in Outlook

Updated April 17, 2017

Stored in the Outlook Contacts folder, distribution lists create a simple means of sending bulk e-mails to numerous recipients. The sometimes tedious task of adding each individual e-mail address might take a great deal of time. You can save time and type less by performing a bulk copy of e-mail addresses from an existing spreadsheet or document, and then paste the addresses into an Outlook distribution list.

Open the Excel spreadsheet containing the email addresses.

Copy the cells containing the email addresses by clicking the "Edit" toolbar, followed by "Copy," or by using the "Control"+"C" keyboard keys. The document should contain one e-mail address per line for the copy to work properly.

Open Outlook and open the distribution list to which you wish to add the addresses.

Click the "Select Members" box from the upper-right corner.

Place the cursor on the line beside "Members." Clicking the line will place the cursor.

Paste the email addresses by clicking the "Edit" toolbar, followed by "Paste," or by using the "Control"+"V" keyboard keys. Click "OK."

Open the Word document containing the email addresses.

Copy the email addresses by clicking the "Edit" toolbar, followed by "Copy," or by using the "Control"+"C" keyboard keys. The document should contain one e-mail address per line for the copy to work properly.

Open Outlook and open the distribution list to which you wish to add the addresses.

Click the "Select Members" box from the upper-right corner.

Place the cursor on the line beside "Members." Clicking the line will place the cursor.

Paste the email addresses by clicking the "Edit" toolbar, followed by "Paste," or by using the "Control"+"V" keyboard keys. Click "OK."

bibliography-icon icon for annotation tool Cite this Article

About the Author

Mindi Orth began writing in 1996 as a technical writer for a consulting firm. She has experience in business documentation and has authored training and instructional materials. Orth holds a Bachelor of Arts in English from Baldwin-Wallace College.