Google表格：Mailto脚本问题

function sendMail(e) {
  
  var cellvalue = e.value;
  var ss = e.source;
  var sheet = ss.getActiveSheet();
  var cell = sheet.getActiveCell().getA1Notation();
  var sheetName = sheet.getName();
  var PRSR = sheet.getRange("B"+e.range.getRow()).getValue();
  
  var aValue = sheet.getRange("A"+e.range.getRow()).getValue();
  var cValue = sheet.getRange("C"+e.range.getRow()).getValue();
  var dValue = sheet.getRange("D"+e.range.getRow()).getValue();
  
  switch(PRSR){
    case "SP":
      recipients = "[email protected]";
      break;
    case "TD":
      recipients = "[email protected]";
      break;
    case "BM":
      recipients = "[email protected]";
      break;
    default:
      recipients = "[email protected]";
      break;
  }

  var message = '';
  if(cellvalue.toUpperCase() === 'NO' && parseInt(e.range.getColumn()) == 6){ 
    
    message = 'Cell ' + cell + ' in Sheet ' + sheetName + ' was changed to NO.';
    message = message + " "+ aValue + " " + cValue + " "+dValue;
    
    var subject = 'Cell Changed to NO in Inspection Checklist';
    var body = message + '  Visit ' + ss.getUrl() + ' to view the changes';
    MailApp.sendEmail(recipients, subject, body);
  }
}