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?

    Librarian in need.

Log in to reply

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