Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Outlook Users: Email a Group of People From a Spreadsheet List

Outlook Users: Email a Group of People From a Spreadsheet List
Image from http://en.wikipedia.org/wiki/Outlook_Web_App
Image from http://en.wikipedia.org/wiki/Outlook_Web_App

Recently a friend messaged me telling me she is using Outlook and wanted to know how to take a column of email addresses in a spreadsheet and use it in the “To” line of the compose email. In Gmail, you can paste the list of email addresses directly from the spreadsheet column into the “To.” Outlook however requires a comma to separate each email address.

The Template

https://alicekeeler.com/outlookemail

Make a copy of the template.

List of Email Addresses

I left columns A and B blank on the spreadsheet in case you wanted to list the persons name, but this is not necessary to utilize the spreadsheet.

In column C type the email address of each person. One per cell.

Appended Emails

As you type in email addresses the cell next to the last email address you type in will contain the complete list of email addresses appended together with a comma.

Copy

Click on this cell that contains the collection of email addresses. Use Control C to copy the list of email addresses. Place your cursor in the “To” line of your Outlook email and use Control V to paste the list.

copy the bottom cell

 

 

 

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.