javascript

Email_Automation

This Code is to be used to automatically send Emails from sheet data.

function SendEmails() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var lr = ss.getLastRow();

for(var i =2;i<=lr;i++)
{
  var currentEmail = ss.getRange(i,1).getValue();
  var currentName = ss.getRange(i,2).getValue();
  var currentLastName = ss.getRange(i,3).getValue();
  var currentPN = ss.getRange(i,4).getValue();
  
  Logger.log(currentEmail);
  MailApp.sendEmail(currentEmail,"Reminder:"+currentName+currentLastName,"Hello User...This is your Phone Number " + currentPN )
}
}

Was this helpful?