有时不会发送电子邮件(如果必须运行第一个子例程，则会跳过第二个子例程）

我的代码在发送电子邮件方面运行良好。它应该向提交表单的用户发送电子邮件。

问题在于，对于某些行，当它需要运行自动审批子例程（代码注释中的 SECTION A）时，它将无法运行下一个子例程（代码注释中的 SECTION B，这是应该实际发送电子邮件的子例程）。

如果我运行整个脚本两次，那么它会发送电子邮件。此外，如果您手动批准行，则会发送电子邮件。但是，如果脚本批准该行，则不会在同一次运行中发送电子邮件。

谷歌企业应用脚本代码：

function sendEmails2() {
  //trying to adopt code from this tutorial https://developers.google.com/apps-script/articles/sending_emails
  //-believe there is an issue with where I am declaring getRange to work-
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2;  // First row of data to process
  var lastRow = 40;   // Last row of data to process
  // Fetch the range of cells A1:B10002
  var dataRange = sheet.getRange(startRow, 1, lastRow, 11)
  // Fetch values for each row in the Range.
  var data = dataRange.getValues();
  for (i in data) {
    var row = data[i];
    var partTimeApproved = row[0]
    var userID = row[2]
    var emailAddress = row[7];  // sometimes this shit is like "invalid email address found" but it sends it anyway
    var isEmailSent = row[9];
    var partTimeApprovedAutomatically = row[10]
    var cc = 'list of CCs'
    //this next section should automatically approve rows submitted by approved users
//  SECTION A
    if (userID == "user 1" || userID == "user 2" || userID == "user 3") {
      if (partTimeApproved != 'Y') {
    sheet.getRange(startRow+parseInt(i, 10), 1).setValue('Y')
    sheet.getRange(startRow+parseInt(i, 10), 11).setValue('Y')
    }
      {}
    }
    {} 
// SECTION B
    var nowIsPartTimeApproved = row[0] // I wrote this in a vain attempt at getting the system to process section A and B at the same time
    if (nowIsPartTimeApproved == 'Y') { // prevents sending emails to non-approved rows. 
    if (isEmailSent == '') {  // Prevents sending duplicates and sending emails to non-approved rows
      var options = {
        cc: cc
      }
      var subject = "Email Subject Test";
      var message = "Email body test";    // Standard string OR sheet.getRange(1,13) ;
      MailApp.sendEmail(emailAddress, subject, message, options)
      sheet.getRange(startRow + parseInt(i, 10), 10).setValue('emailSent'); //trying this from Stackoverflow's epascarello
      // Make sure the cell is updated right away in case the script is interrupted
      SpreadsheetApp.flush();
    }
  }
  }
}

有什么想法吗？