function sendEmails() {

  

  var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

  var lr = ss.getLastRow();

 

  var templateText = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Template").getRange(1, 1).getValue();

  var quotaLeft = MailApp.getRemainingDailyQuota() - 90;

  

  Logger.log(quotaLeft)

  if ((lr-1) > quotaLeft){

    

    Browser.msgBox("You have " + quotaLeft + "left and yo´re trying to send " + (lr-1) + " emails. Emails are not sent.");

  } else {

  for (var i = 2;i<=lr;i++){

    

    var currentEmail = ss.getRange(i, 1).getValue();

    var currentName = ss.getRange(i, 2).getValue();

    var currentClass = ss.getRange(i, 3).getValue();

    var currentP1 = ss.getRange(i, 4).getValue();

    var currentP2 = ss.getRange(i, 5).getValue();

    var currentSeminario = ss.getRange(i, 6).getValue();

    var currentProjeto = ss.getRange(i, 7).getValue();

   

    var currentNota = ss.getRange(i, 8).getValue();

    var currentFrequencia = ss.getRange(i, 9).getValue();

    

    var messageBody = templateText.replace("{nome}",currentName).replace("{nota}",currentNota).replace("{class}",currentClass).replace("{P1}",currentP1).replace("{P2}",currentP2).replace("{S}",currentSeminario).replace("{P}",currentProjeto).replace("{frequencia}",currentFrequencia);

    

    Logger.log(messageBody);

           

    MailApp.sendEmail(currentEmail, "Divulgação", messageBody);

    

     }//close for looping

  

  } //close else statement

    

}