Email with Status change?
-
Hello,
SO I have a form and I want it to be able to send a pre-prepared email whenever I change the status in column o to the email in column L. 0_1529531041171_1.PNG But I am not sure how to do that. I found this code:
function CustomEmail() {
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getRange("A2:O100");
var UserData = range.getValues();
for (i in UserData) {
var row = UserData[i];
var name = row[k];
var email = row[l];
var score = row[0];
MailApp.sendEmail(row[1], "Custom mail", "Hello " + name + ", This is an email report of your article request. Your article is " + score);
}
}But I'm not sure it can help?
Thanks!
Librarian in need.