Lesson 9: Merge Emails from Spreadsheet Data
Lesson 9: Merge Emails from Spreadsheet Data
Total video watch time - 16:33
Embedded Files
LESSON OBJECTIVES
LESSON OBJECTIVES
Install the Yet Another Mail Merge Add-on
Prep your sheet for a mail merge
Create a draft email
Configure the YAMM Add-on
Run a mail merge
Install the Yet Another Mail Merge Sheets Add-on
Install the Yet Another Mail Merge Sheets Add-on
Open up any Google Sheet in your personal Google Account
In the Extension menu, click Add-ons, then Get add-ons
Search Yet Another Mail Merge.
Click on the add-on and install it
Once done, you will see Yet Another Mail Merge: Mail Merge for Gmail in your list of Add-ons when you click on the Extensions menu.
Set Up Your Spreadsheet
Set Up Your Spreadsheet
Mail Merging allows you to send bulk personalized emails to students, parents, and colleagues using spreadsheet data.
There are many ways that mail merges can be used to assist you.
Send confirmation emails
Provide next steps
Email quiz results
As a Digital Breakout clue
The first step before running a mail merge, is to ensure that your spreadsheet contains all the data that you would want to personalize your email. Data can be added to a spreadsheet manually or by using a formula.
Set Up a Draft Email
Set Up a Draft Email
Once your spreadsheet contains the data you need, you are ready tp setup a draft email in Gmail. Yet Another Mail Merge, will use this draft as a template. In this video you will learn how to use Merge Tags in a draft email in order to personalize each email sent with data from your spreadsheet.
Configure and Run a Mail Merge
Configure and Run a Mail Merge
Once your spreadsheet and draft email is setup, you ready to run your first mail merge campaign! This video will show you how to manually run a mail merge as well as how to automatically send an email upon a form submission (assuming the data in the spreadsheet is populated from a Google Form). Automating these emails will save you time and improve communication.
LESSON TASK
LESSON TASK
IMPORTANT: Before opening the practice task, make sure you are viewing this page with your personal Google Chrome account. This will ensure that a copy of the task is created in your personal Google Account. If you open the task in your school account, some features may be blocked and you will not be able to submit the assignment to Google Classroom.
Click the Practice Task button below, then select the "USE TEMPLATE" button to create an editable copy of the task in your Google Drive.
Follow the steps in the INSTRUCTIONS tab
Click the Solution File button to check your work.
When you have completed the task to the best of your ability, find the "TURN IN" tab in the Practice Task for instructions on how to submit your work.
Page updated
Google Sites
Report abuse