Steps before watching this video. 1) Create A Google Account3) Create A New Spreadsheet 4) Follow Steps In Video To Create Your Test. (Note: you must be logged into you Google Account.) Link to the Template For more help: Google Spreadsheet Function List | Copy The Following Codefunction sendEmails() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[5]; var startRow = 1; // First row of data to process var numRows = 1; // Number of rows to process // Fetch the range of cells A1:D1 var dataRange = sheet.getRange(startRow, 1, numRows, 5) // Fetch values for each row in the Range. var data = dataRange.getValues(); for (i in data) { var row = data[i]; var emailAddress = row[1]; // First column var subject = row[2]; // Second column var message = row[3]; // Third column MailApp.sendEmail(emailAddress, subject, message); } } |