Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var vJOresponses = ss.getSheetByName("Responses");
- var vCodesDay = ss.getSheetByName("Codes")
- var vLength = vJOresponses.getRange("C2").getValue();
- var vResults = vJOresponses.getRange("D2").getValue();
- var vemailAddresses = vJOresponses.getRange("B2").getValue();
- var vsubject = "Here are your Wi-Fi codes!";
- var dataRangeDay = vCodesDay.getSheetValues(1, 1, vResults, 1);
- MailApp.sendEmail(vemailAddresses, vsubject, dataRangeDay)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement