The auto mail sending google sheet scripts | Arfius

function BulkEmailSender() {

 

varA = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Sheet1”);
varB = A.getLastRow();

 

for (varC = 2; C <= B; C++) {

 

varEmailList = A.getRange(C, 1).getValue();
varSubjectList = A.getRange(C, 2).getValue();
varMessageList = A.getRange(C, 3).getValue();

 

MailApp.sendEmail(EmailList, SubjectList, MessageList);

 

}
}

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top