I'm trying to loop through an spreadsheet, and for each row send an email. Once the email is sent, i'd like to delete that row.
That however is not working.
For some reason, it starts sending emails like crazy, and at some point it reaches the limit and quits.
It actually only deletes one row.
See the code below:
function sendEmails() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var startRow = 2; // First row of data to process
var maxRows = sheet.getMaxRows();
var range = sheet.getRange(startRow, 1, maxRows, 50)
var values = range.getValues();
for (var row in values) {
Logger.log('ID=' + values[row][0]);
var theID = values[row][0];
var message = ;
var sendto = ;
var emailAddress = values[row][2];
if (emailAddress==Autre){[email protected]}
if (emailAddress==Autre1){[email protected]}
if (emailAddress==Autre2){[email protected]}
message+=n ID: + values[row][1];
message+=n Project Number: + values[row][2];
var subject = Project ID: + values[row][1];
if (sendto!=''){
MailApp.sendEmail(sendto, subject, message);
sheet.deleteRow(row+2)
}
}
Logic is, if there's a valid email, send the email, delete the row.
But once it executes, it only deletes one row, sends emails like crazy, and get the email max error.
Thoughts?