function sendEmails() { var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 2; // First row of data to process var numRows = 117; // Number of rows to process // Fetch the range of cells A2:B118 var dataRange = sheet.getRange(startRow, 1, numRows, 2) // Fetch values for each row in the Range. var data = dataRange.getValues(); for (i in data) { var row = data[i]; var emailAddress = row[0]; // First column var message = row[1]; // Second column var subject = "ICU List Update"; if (emailAddress.length > 0){ MailApp.sendEmail(emailAddress, subject, message); } } }