I am writing an email function that is supposed to send an email from ALL the range data in the spreadsheet after clicking a button, the problem is I cannot get one email with all the data, instead, every email is sent individually through the loop, is there a way that I can have all data sent in as HTML data in one email? When I place var htmlMessage=emailTemp.evaluate().getContent(); outside the loop it triggers BarcodeT is not defined.
function email(){
var Barcode=0;
var Name=1;
var Added=2;
var Price=3;
var emailTemp=HtmlService.createTemplateFromFile("Email");
var ws=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Refill Request");
var data = ws.getRange("A3:D" + ws.getLastRow()).getValues();
let BarcodeT="";
let NameT="";
let AddedT="";
let PriceT="";
data.forEach(function(row){
BarcodeT+=emailTemp.ItemCode=row[Barcode];
NameT+=emailTemp.ItemName=row[Name];
AddedT+=emailTemp.QuantityNeeded=row[Added];
var htmlMessage=emailTemp.evaluate().getContent();
})
var address = "test@gmail.com";
MailApp.sendEmail(address,"Refill Request","Your email doesn't support HTML.",
{name: "Email App", htmlBody: htmlMessage})<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<table>
<tr>
<th>Item Code</th>
<th>Item Name</th>
<th>Quantity Needed</th>
</tr>
<tr>
<td><?=BarcodeT ?></td>
<td><?=ItemName ?></td>
<td><?=QuantityNeeded ?></td>
</tr>
</table>
</body>
</html>In your script, how about the following modification?
function email() {
var Barcode = 0;
var Name = 1;
var Added = 2;
var ws = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Refill Request");
var data = ws.getRange("A3:D" + ws.getLastRow()).getValues();
var htmlMessage = "<table><tr><th>Item Code</th><th>Item Name</th><th>Quantity Needed</th></tr>";
data.forEach(function (row) {
htmlMessage += `<tr><td>${row[Barcode]}</td><td>${row[Name]}</td><td>${row[Added]}</td></tr>`;
});
htmlMessage += "</table>";
var address = "test@gmail.com";
MailApp.sendEmail(address, "Refill Request", "Your email doesn't support HTML.", { name: "Email App", htmlBody: htmlMessage });
}