Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function ProcessList() {
- var sheet = SpreadsheetApp.getActiveSheet();
- var dataRange = sheet.getDataRange();
- var data = dataRange.getValues();
- for (var i = 2; i<data.length; i++)
- {
- Logger.log("Quota before = " + MailApp.getRemainingDailyQuota());
- sendMail(data[i]);
- Logger.log("Quota after = " + MailApp.getRemainingDailyQuota());
- }
- }
- function sendMail(row)
- {
- Logger.log(row);
- var to = row[2];
- var cc = row[3];
- var bcc = row[4];
- var date = row[5];
- var subject = row[6];
- var body = row[7];
- MailApp.sendEmail(to, subject, body);
- }
Add Comment
Please, Sign In to add comment