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

 

 

 

1 thought on “Outlook Users: Email a Group of People From a Spreadsheet List

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

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

Join Alice Keeler for this session as we learn how to revolutionize your assessment strategies. We will dive into the essentials of crafting high-quality rubrics that go beyond traditional scoring methods to offer rich, meaningful feedback. We’ll learn about the components of an effective rubric and how to mathematically ensure the accuracy of your assessments.

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