Alice demonstrates how to code a Mail Merge. She starts off with creating a spreadsheet with all the names, email addresses and the "data" you want to send out. Open a new tab and create a unique "template" of some kind that you want to send to each person. Start the message with <<Name>> which is a "merge tag". On the spreadsheet you will go to "extensions" and "Apps script". You will then code the function to "merge" and "get active spreadsheet" and use the "document Id" to access it. Watch the full webinar for each specific step to code the Mail Merge. Students will then each receive an email with a personalized document.
Paperless Is Not a Pedagogy