![]() All the best and please use the class space to read updates on your team's tasks!" ![]() Message = "Hi " + studentName + "! For the Mission to Mars Robotics project you have been put in Team " + team + " and your due date for the submission" ![]() Now it is time to create your unique message for the student/parents. Var pEmail = data //will load parent email for later email sending Var studentMail = data //will load student email for later email sending Var dueDate = data //will load the unique due date for this student's team. Var team = data //will load the TEAM name for each row into this space. Var studentName = data //will load the name "Noemi Blevins" since it is in 2nd row and 1st column. Var message = "" //blank message which will hold fresh data for each row/student when emails go off. Loop all the way to the end of the data This line means start at index 1 (since 0 is the column header we dont care about) Now make a loop that will go through this data array ONE ROW AT A TIME Var data = sheet.getDataRange().getValues() Now load all the data in that sheet into a 2D array (matrix) Var sheet = SpreadsheetApp.getActive().getSheetByName("Sheet1") #Mail merge google sheets codeStep 3: This will open up your Script Editor where you will type in this code needed to send off the emails. So click on Tools > Script Editor for the Sheet. Step 2: Now, we need to write the code which sends off the emails. Fake names and email address created via You can add whatever unique information you want here. Step 1: Get your Google Sheet prepared with basic recipient information. Maybe you already have a system in place for this and if so please treat this blog post as a way to learn about Google Scripts! Instructions But if I want to send off a set of emails to kids and their parents letting them all know of their grade data or of some event that requires them to be in groups etc, then this approach is my preferred one. Now, it may not look as visually appealing since the formatting takes some effort. Given my natural affection towards writing my own solutions I have used good old Google scripts to read data from a Sheet and fire off emails based on content that is built into the script. We do use services like SendGridbut mainly for all school mass emailing that doesn’t require any personalized element. #Mail merge google sheets installPlus, to send a quick message with basic information it seemed like a lot of work to install and run the add on. Often times the recipients are parents who do not have a school account so importing them into the contacts can be tricky. I have tried turning to services like YAMM (Yet Another Mail Merge) but the challenge was making the recipients my contacts which was not always possible. ![]() This has been hit or miss given our mail server settings and over time, has been inconsistent. But we use Gmail at my current school so I have had to install a unique account for just mail merge on Outlook. Sending emails via Mail Merge was easier at my previous school where Outlook was the default mailing service. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |