function sendEmails() {
var sheet = Spreadsheetapp.getactiveSheet();
var startRow = 2; // First row of data to process
var numRows = 2000; // Number of rows to process
// Fetch the range of cells A2:B3
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 = "Sending emails from a Spreadsheet";
MailApp.sendEmail(emailaddress,subject,message,{noReply:true});
}
}
在这里,我想将C2,D2,E2,F2行数据发送到A2,并将C3,D3,E3,F3行数据发送到A3,并且循环应该在工作表中的所有行上运行。 >
我有一个脚本将常见主题发送给所有人。
有人可以帮我按上述方式发送数据