79554701

Date: 2025-04-04 07:29:26
Score: 0.5
Natty:
Report link

I was able to make it work ... partially. The image now appears as an attachment.

function sendEmails() {
  var templateData = getData("Templates");
  var emailSubjectTemplate = templateData[1][0]; //Cell A2
  var emailBodyTemplate = templateData[4][0]; //Cell A5
  var emailData = getData("Data");
  var logo = DriveApp.getFileById("1PyDU0sOYW_OSMQ1vNpXn9JGf7-I7_dBL").getAs("image/png");
  emailData = rowsToObjects(emailData);
  emailData.forEach(function (rowObject) {
    var subject = renderTemplate(emailSubjectTemplate, rowObject);
    var body = renderTemplate(emailBodyTemplate, rowObject);
    let emailImages = {"logo":logo}
    MailApp.sendEmail(rowObject["Email Address"], subject, body, {inlineImages: emailImages});
  });
}
Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: kimmandy36