Note that what the column header says will NOT appear in the emails you send out.
Spelling counts so you need to make sure that your merge tag is exactly the same as the column header. The merge tag for the mail merge is to place the column header in between double less than and double greater than symbols. I want the email to address the student personally so I start the draft email with: Hello, Anywhere in the email where you want to insert information from the spreadsheet you put a placeholder merge tag.įor example, I always collect the students name. You will find the Add-On already installed in future spreadsheets.
#Google doc merge field install#
Install Add-Onįrom the spreadsheet the Google Form is linked to, install the Add-On “Yet Another Mail Merge.” This only needs to be done once. Mail merge allows me to send the student the rubric scores and my comments. I use a Google Form with a rubric and comment fields to evaluate student projects. I use mail merge to send student peer review comments.
#Google doc merge field free#
This allows me to respond to student free response answers in a quiz and give them email notification of my comments. When you are not using Flubaroo you can use the Add-On “ Yet Another Mail Merge” to email information from a Google Form. The Flubaroo Add-On allows you to add personalized comments to each students responses before emailing back quiz scores.
If you use Google Forms with students you can use mail merge to provide students with feedback.
0 kommentar(er)
