Guest User

Untitled

a guest
Jul 22nd, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. function ProcessList() {
  2. var sheet = SpreadsheetApp.getActiveSheet();
  3. var dataRange = sheet.getDataRange();
  4. var data = dataRange.getValues();
  5.  
  6.  
  7.  
  8. for (var i = 2; i<data.length; i++)
  9. {
  10. Logger.log("Quota before = " + MailApp.getRemainingDailyQuota());
  11. sendMail(data[i]);
  12. Logger.log("Quota after = " + MailApp.getRemainingDailyQuota());
  13.  
  14. }
  15.  
  16. }
  17.  
  18.  
  19. function sendMail(row)
  20. {
  21. Logger.log(row);
  22.  
  23. var to = row[2];
  24. var cc = row[3];
  25. var bcc = row[4];
  26. var date = row[5];
  27. var subject = row[6];
  28. var body = row[7];
  29.  
  30. MailApp.sendEmail(to, subject, body);
  31. }
Add Comment
Please, Sign In to add comment