BookmarkPrint
Contents
Home > Microsoft Office > Outlook > Outlook Mail > Copy Email Addresses From Excel - Outlook


Copy Email Addresses From Excel - Outlook
How to copy a list of email addresses from Excel and send a new email or use it to create a new contact group in Outlook.
Quick links to sections in this article: 
Copy Into New Email
Copy Into New Contact Group


Copy Into New Email

Step 1:
Open the list of e-mail addresses in Excel. Step 2:Select the addresses to whom you would like to send messages.

Step 3:Right click on the selection and choose Copy. Alternatively, press [Ctrl] + [C] to copy.

Step 4:Open Outlook and create a new e-mail.

Step 5:Right click in the To... (or Cc, Bcc) text box and select Paste, or press [Ctrl] + [V].

Step 6:The addresses will appear in a list.

Step 7:Click anywhere outside the text box. The addresses will be separated as individual recipients.



Copy Into New Contacts Group

Step 1: Open the Excel contacts spreadsheet.
Step 2: Select the Email cells. Right click on the selection and select Copy, or press [Ctrl] + [C].


Step 3:
Minimize Excel.
Step 4:
Open Outlook. Go to Contacts.
 
Step 5: On the Home ribbon, click New Contact Group.

Step 6:
Click in the Name box and type the name of the Contact Group. Spaces are OK to use.
 
Step 7: Click Add Members, From Address Book.
 
Step 8: Click on Members - >.

Step 9: Right click and choose Paste, or press [Ctrl] + [V] . Click OK.
 
Step 10: Individual email addresses appear in alphabetical order. Click Save & Close.


Related Articles


helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=copy_email_addresses_from_excel