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.


Log in to reply
 

Looks like your connection to Codingislove Forum was lost, please wait while we try to reconnect.