Don'如果“不希望发送电子邮件”;Null”;单元格中的值

Don't want email to send if "Null" Value in cell

本文关键字：Null 电子邮件 单元格 如果 希望 Don      更新时间：2024-03-26

如果emailSentCol！==电子邮件发送。如果电子邮件SentCol中的单元格为空，我也希望它不要发送。有什么建议吗？谢谢大家。12号线

function myFunction() {
  var EMAIL_SENT = "EMAIL_SENT";
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Administrators");
  if (sheet != null) {
    var data = sheet.getDataRange().getValues();
    var startRow = 1; //The starting row of data (zero indexed)
    var emailCol = 1; //The column that the email address is in (zero indexed)
    var messageCol = 28; //The column that the message is in (zero indexed)
    var emailSentCol = 29; //The column that the EMAIL_SENT note is in (zero indexed)
    for (var i = startRow; i < data.length; i++) {
      if (data[i][emailSentCol] !== EMAIL_SENT) {
        var emailAddress = data[i][emailCol];
        var subject = "Tuition Reimbursement Status";
        var message = data[i][messageCol];
        if(emailAddress !== null && emailAddress !== '' && emailAddress !== "") {
          MailApp.sendEmail(emailAddress, subject, message);
          sheet.getRange(i+1,emailSentCol+1).setValue(EMAIL_SENT);
        }
      }
    }
  }

将if构造修改如下：

if (data[i][emailSentCol] && data[i][emailSentCol] !== EMAIL_SENT) {

这确保了在检查数据[i][emailSentCol]是否未发送之前，数据[i][EmailSentColo]必须定义为非空。

相关文章：