Convert Email Addresses in Excel to Outlook Email List

From WSU Technology Knowledge Base
Jump to navigation Jump to search

How do you convert a column of email addresses in Excel to a useable distribution list in Outlook?

Note:

These instructions work for both PC and Mac computers, using Outlook or Outlook Web Access. The email addresses must be complete (name@server.xxx) and listed in a single Excel column to use these instructions successfully.

Steps:

  1. Copy and paste the column of email addresses into a blank Microsoft Word document.
  2. A small clipboard appears to the right of the data. Click on this once and select Keep Text Only.
  3. Click the REPLACE button on the Home tab (sometimes found under Edit > Replace).
  4. Click inside the “Find” box and enter ^p. (Hint: The carat symbol “^” is typed using Shift-6.)
  5. Click inside the “Replace” box and type in a semi-colon. (Hint: The semi-colon key on most keyboards is to the immediate right of the letter L.)
  6. Click the REPLACE ALL button. When the process is finished, hit OK and close the Find/Replace window.

You now have a list that can be copy and pasted into the TO,CC,or BCC sections of an Outlook email message.

Imagesomething.png