var CONFIRMATION_SENT = "CONFIRMATION_SENT";

function managernotification(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Florence");
  var startRow = 1;
  var range = sheet.getDataRange();
  var data = range.getValues();
  for (var i = 3; i < data.length; ++i) {
    var confirmationSent = data[i][11];
    var userName = data[i][2];
    var userEmail = "jerome.mo@mercy-pharmacy.com" + "," + "chad.vo@mercy-pharmacy.com";
    var startdate = data[i][3];
    var enddate = data[i][4];
    var subject = "[MPG] - Time-Off Request Submitted";
    var message = "Hello,\n\n" + userName + " has requested for a time-off from " + startdate + " to " + enddate + "\n\nPlease respond 'Approved' or 'Denied' to this email with your decision" + "\n\nBest,\nHR Manager";
    if (confirmationSent !== CONFIRMATION_SENT){
      MailApp.sendEmail (userEmail, subject, message,{name:"Human Resources Manager"});
      sheet.getRange(startRow + i, 12).setValue(CONFIRMATION_SENT);
    SpreadsheetApp.flush();}
  }
}