How come my forEach loop gets error when sending emails

Question

I am sure the answer is staring at me right in the face but I'm a bit confused. I have a spreadsheet with employee information and I created a forEach loop (below) so that at the end of each row it should send an email with information from the row. However, the HTML file is not recognizing value[0], value[1], etc and I am getting the following error message: ReferenceError: value is not defined

function ncnsEmailFunction () {

const values = ncnsSheet.getRange(2, 1, 10, 6).getValues();

values.forEach(function(value, index){
if (value[0] === "") return;

const htmlBody = HtmlService.createTemplateFromFile("NCNSEmailTemplate").evaluate().getContent();
MailApp.sendEmail({
  to: Session.getActiveUser().getEmail(),
  subject: `NCNSEmailTemplate`,
  htmlBody: htmlBody,
  });

})

}

Here is what my HTML file looks like:

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body>

Hello <?=value[0]?>

  </body>
</html>

What can I do to fix this?

ncnsSheet is undefined

Cooper
– Cooper

2022-09-20 01:19:55 +00:00
Commented Sep 20, 2022 at 1:19 — Cooper
– Cooper, Commented Sep 20, 2022 at 1:19

Cooper · Accepted Answer · 2022-09-20 00:48:21Z

3

Try this:

function ncnsEmailFunction() {
  const ss = SpreadsheetApp.getActive();
  const ncnsSheet = ss.getSheetByName("Your sheet name")
  const values = ncnsSheet.getRange(2, 1, 10, 6).getValues();
  values.forEach(function (value, index) {
    if (value[0] === "") return;
    let t = HtmlService.createTemplateFromFile("NCNSEmailTemplate");
    t.value = value[0];
    const htmlBody = t.evaluate().getContent();
    MailApp.sendEmail({to: Session.getActiveUser().getEmail(),subject: `NCNSEmailTemplate`,htmlBody: htmlBody});
  })
}

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body>
Hello <?=value?>
  </body>
</html>

edited Sep 20, 2022 at 0:48

answered Sep 20, 2022 at 0:42

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Borgher Over a year ago

Ok perfect! I was just playing around with the following line and it helped fix the issue, this is good to know for future projects: t.value = value[0];

Collectives™ on Stack Overflow

How come my forEach loop gets error when sending emails

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related