Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function activeRowEmail() {
- var sheet = SpreadsheetApp.getActiveSheet();
- var activeRow = sheet.getActiveCell().getRowIndex();
- var name = sheet.getRange(activeRow, 1).getValue();
- var email = sheet.getRange(activeRow, 2).getValue();
- var score = sheet.getRange(activeRow, 3).getValue();
- MailApp.sendEmail(email,"custom email","hello " + name + ", This is an email report of your score. Your score is " + score);
- }
- ##credits - https://codingislove.com
Add Comment
Please, Sign In to add comment