Advertisement
Guest User

Untitled

a guest
Jul 25th, 2014
236
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. var ss = SpreadsheetApp.getActiveSpreadsheet();
  2. var vJOresponses = ss.getSheetByName("Responses");
  3. var vCodesDay = ss.getSheetByName("Codes")
  4. var vLength = vJOresponses.getRange("C2").getValue();
  5. var vResults = vJOresponses.getRange("D2").getValue();
  6. var vemailAddresses = vJOresponses.getRange("B2").getValue();
  7. var vsubject = "Here are your Wi-Fi codes!";
  8. var dataRangeDay = vCodesDay.getSheetValues(1, 1, vResults, 1);
  9.  
  10. MailApp.sendEmail(vemailAddresses, vsubject, dataRangeDay)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement