Emailing a List of People from a Spreadsheet Column

Do you have a list of email addresses of parents, colleagues, students, or friends saved on a spreadsheet (Google Sheets or Microsoft Excel)?

The email addresses must be complete (for example: cf_lastf@cftigers.org) and listed in a single spreadsheet column to use these instructions successfully. The only other program you need is Microsoft Word. Unfortunately, Google Docs DOES NOT work for this shortcut.

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 (or Ctrl + H).
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 email message.