function sendEmails() {
try{
var ss = SpreadsheetApp.getActiveSpreadsheet()
var sheet = ss.getSheetByName("email")
var arrData = sheet.getRange("A3:A" + sheet.getLastRow()).getDisplayValues()
var arrEmails = []
for(var i = 0; i< arrData.length; i++){
var email = arrData[i][0]
if(email.length > 1 && email.search("@") > 0){
arrEmails.push(email)
}
}
var emailCount = arrEmails.length
if(emailCount < 1){
Browser.msgBox("Внимание", "Нет валидных Emails в списке", Browser.Buttons.OK)
return
}
var subject = sheet.getRange("C1").getDisplayValue()
var tableName = sheet.getName()
var dopText = sheet.getRange("C2").getDisplayValue()
var isNotOneMail = Boolean(sheet.getRange("C3").getDisplayValue() == "ДА")
var sendEmailCount = 0
if(isNotOneMail){
sendEmailCount = sendEmailsSeparate_(emailCount, arrEmails, subject, tableName, dopText)
} else {
sendEmailCount = sendEmailsInOne_(emailCount, arrEmails, subject, tableName, dopText)
}
var remainingEmails = MailApp.getRemainingDailyQuota()
Browser.msgBox("Внимание!", "Отправлено " + sendEmailCount +
" Emails\\nОстаток квоты на сегодня: " + remainingEmails, Browser.Buttons.OK)
} catch(error){
Browser.msgBox(error)
}
}