So I needed to convince students to open up an email on a Friday night, so they would know to come in to Saturday School the next day.\u00a0 So I decided to use YAMM!\u00a0 YAMM is Yet Another Mail Merge, and it is an add on for google sheets.<\/p>\n
How do you use it to send emails to each of your students?<\/p>\n
1. Write a draft of the email that you want to send but don’t send it, keep it as a draft.\u00a0 In the email if there are places where you want the student’s first or last name to appear use <<first>> or <<last>>.\u00a0 Here is the email that I sent:<\/p>\n
Dear <<First>>,<\/p>\n
<\/div>\nI’m coming back early from my conference because I wanted to make sure that as many students earn credit as possible.\u00a0 Given that you, yes you <<First>> <<Last>>, have a chance to earn credit, please come to Saturday school to take advantage of it.\u00a0 If you already gave the assignment to one of my assistants, let me know.<\/div>\n<\/div>\nI hope to see a lot of kids on Saturday,<\/div>\n<\/div>\nCarl<\/div>\n<\/blockquote>\nThe next step is to create a google sheet with the kids first and last name, as well as their email addresses in each row.\u00a0 It’s important that the first column of the spreadsheet have the headers, which would be ‘first’, and ‘last’ above the columns with that information.\u00a0 Inside of this google sheet, you can go to the add on market place, search for YAMM and authorize it.<\/div>\n<\/div>\nThe final step is to go through and carry out the YAMM instructions.\u00a0 It walks you through it, but here are the basics.\u00a0 The first window will ask if you want to buy anything, but purchases are optional.\u00a0 It will ask you for the recipients, which would be the email addresses.\u00a0 Then, you choose the draft and it loads all of the recent draft emails from the associated email account.\u00a0 Finally, you can test send the emails, or send them all!<\/div>\n","protected":false},"excerpt":{"rendered":"So I needed to convince students to open up an email on a Friday night, so they would know to come in to Saturday School the next day.\u00a0 So I decided to use YAMM!\u00a0 YAMM is Yet Another Mail Merge, and it is an add on for google sheets. How do you use it to […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"Clog: Using YAMM to send personal emails to students","jetpack_is_tweetstorm":false},"categories":[24],"tags":[11],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4xz6U-7w","_links":{"self":[{"href":"https:\/\/www.coast2coast.me\/carl\/wp-json\/wp\/v2\/posts\/466"}],"collection":[{"href":"https:\/\/www.coast2coast.me\/carl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.coast2coast.me\/carl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.coast2coast.me\/carl\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.coast2coast.me\/carl\/wp-json\/wp\/v2\/comments?post=466"}],"version-history":[{"count":2,"href":"https:\/\/www.coast2coast.me\/carl\/wp-json\/wp\/v2\/posts\/466\/revisions"}],"predecessor-version":[{"id":468,"href":"https:\/\/www.coast2coast.me\/carl\/wp-json\/wp\/v2\/posts\/466\/revisions\/468"}],"wp:attachment":[{"href":"https:\/\/www.coast2coast.me\/carl\/wp-json\/wp\/v2\/media?parent=466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.coast2coast.me\/carl\/wp-json\/wp\/v2\/categories?post=466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.coast2coast.me\/carl\/wp-json\/wp\/v2\/tags?post=466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}