Emailing a List of People from a Spreadsheet Column
Post date: Oct 13, 2016 4:20:34 PM
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:
- Copy and paste the column of email addresses into a blank Microsoft Word document.
- A small clipboard appears to the right of the data. Click on this once and select Keep Text Only.
- Click the REPLACE button on the Home tab (or Ctrl + H).
- Click inside the “Find” box and enter ^p. (Hint: The carat symbol “^” is typed using Shift-6.)
- 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.)
- 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.