teste google script
function sendEmails() {
var ss=SpreadsheetApp.openById("ssid");
var sheet=ss.getSheetByName('**********Your sheet name***********');
var startRow=2;
var numRows=2;
var dataRange=sheet.getRange(startRow, 1, numRows, 2);
//changed to getDisplayValues
var data=dataRange.getDisplayValues();
//changed to for loop
for (var i=0;i<data.length;i++) {
var row=data[i];
var emailAddress=row[0];
var message=row[1];
var subject='Sending emails from a Spreadsheet';
MailApp.sendEmail(emailAddress, subject, message);
}
}
Are there any code examples left?
New code examples in category Other
-
Other 2023-03-27 22:50:10 how to select the whole line in vscode with keyboard shortcut
-
Other 2022-03-27 22:45:24 income of a web developer
-
Other 2022-03-27 22:35:01 \pyrcc_main.py: File does not exist 'resources.qrc'
-
Other 2022-03-27 22:30:45 rick roll embed code
-
Other 2022-03-27 22:20:08 Circuit_04_Potentiometer
-
Other 2022-03-27 22:20:05 iterative power
-
Other 2022-03-27 22:15:11 flutter run all
-
Other 2022-03-27 22:10:05 when is karlson release
-
Other 2022-03-27 22:10:02 wp .htaccess example
-
Other 2022-03-27 22:00:08 bash pause in file read line by line