無法讀取null錯誤的屬性“getRange”。我很肯定作業表存在并且在腳本中正確命名

我和我的老師們喜歡給學生們發送一些谷歌的小圖畫，讓他們知道他們最近做得很好。我們有一個我們使用的電子表格，我正在嘗試在他們的繪圖準備好查看時自動化向他們發送電子郵件的程序。即使我 100% 確定名稱為 PR 的作業表存在并且拼寫正確，我仍不斷收到“無法讀取屬性 'getRange' 的空錯誤”。我是谷歌腳本的新手，所以我缺乏排除故障的技能，而我已經完成了谷歌搜索，這基本上只是說確保你正確命名了作業表。任何幫助將不勝感激！

  var studentFirstNameRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getRange("A2:A"); 
  var studentFirstname = studentFirstNameRange.getValues();
  var studentEmailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getRange("D2:D"); 
  var studentEmail = studentEmailRange.getValues();
var emailSendRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getRange("L2:L"); 
  var emailSend = emailSendRange.getValues();
  if (emailSend){
    // Send Alert Email.
    var message = 'Hi '   studentFirstname   '! Your teachers noticed you have been doing a great job this year, so we made this for you! Keep up the great work!' ; // Second column
    var subject = 'Positive Recognition';
    MailApp.sendEmail(studentEmail, subject, message);
    }
}```

uj5u.com熱心網友回復：

根據標題和您相關的錯誤，我沒有收到任何錯誤。

但是，我不了解您的條件，也不了解您if (emailSend)發送電子郵件的方式。如果您一次向所有人群發送電子郵件，您可以嘗試

function myFunction() {
  var lastRow = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getLastRow()
  var studentFirstNameRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getRange("A2:A" lastRow); 
  var studentFirstname = studentFirstNameRange.getValues();
  var studentEmailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getRange("D2:D" lastRow); 
  var studentEmail = studentEmailRange.getValues();
  var emailSendRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getRange("L2:L" lastRow); 
  var emailSend = emailSendRange.getValues();
  if (emailSend){
    // Send Alert Email.
    var message = 'Hi '   studentFirstname   '! Your teachers noticed you have been doing a great job this year, so we made this for you! Keep up the great work!' ; // Second column
    var subject = 'Positive Recognition';
    Logger.log(studentEmail.join())
    MailApp.sendEmail(studentEmail.join(), subject, message);
  }
  console.log('there is no errors!')
}

如果您想單獨發送

function myFunction() {
  var lastRow = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getLastRow()
  var studentFirstNameRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getRange("A2:A"   lastRow);
  var studentFirstname = studentFirstNameRange.getValues();
  var studentEmailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getRange("D2:D"   lastRow);
  var studentEmail = studentEmailRange.getValues();
  var emailSendRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('PR').getRange("L2:L"   lastRow);
  var emailSend = emailSendRange.getValues();
  for (var i = 0; i < studentFirstname.length; i  ) {
    if (emailSend[i][0]) {
      // Send Alert Email.
      var message = 'Hi '   studentFirstname[i][0]   '! Your teachers noticed you have been doing a great job this year, so we made this for you! Keep up the great work!'; // Second column
      var subject = 'Positive Recognition';
      MailApp.sendEmail(studentEmail[i][0], subject, message);
    }
  }
}

標籤：

上一篇：學習Promises，Async/Await來控制執行順序

下一篇：瀏覽器和MSOutlook中電子郵件簽名的不同顯示