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
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.
| Author: karperc | Last Updated: 8/23/2017 9:16 AM | Page Views: 2559 |
helpdesk.etown.edu/helpconsole2012/KB/default.aspx?pageid=copy_email_addresses_from_excel
|