Google Apps脚本[电子邮件发送]-Java 学习之路

有没有办法在电子邮件整理器中输出'message'？现在，它只发送给用户的1行长数据 . 我尝试使用 <br> 但它似乎没有用 .

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getDataRange();
  var data = range.getValues();
  setUpCalendar_(data, range);
  var message = "";
  for (i in data) {
    var row = data[i];
    var subject = "Compiled List for " + row[0];

    message += row[0] + row[1] + row[2] + row[3]; 

  }
  MailApp.sendEmail("emailgoeshere", subject, message);
}

2 回答

如上面的评论所述，这已经解释了几次......

下面是一个以文本格式和html格式发送数据的示例，以便拒绝html内容的收件人仍会看到可读的内容;-)

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getDataRange();
  var data = range.getValues();
  setUpCalendar_(data, range);
  var txt = "";
  var html = '<table style="background-color:lightblue;border-collapse:collapse;" border = 1 cellpadding = 5><tr>'
  for (i in data) {
    var row = data[i];
    var subject = "Compiled List for " + row[0];
    txt += row[0] +' - '+ row[1]  +' - '+ row[2]  +' - '+ row[3]+'\n'; 
    html+= '<td>'+row[0] +'</td><td>'+ row[1]  +'</td><td>'+ row[2]  +'</td><td>'+ row[3] +'</td></tr><tr>'; 
  }
  html += '</tr></table>';
  MailApp.sendEmail('an email adress', subject, txt,{'htmlBody':html});
}

根据您的口味更改背景颜色

回复于 2024-04-19T14:59:15+08:00

0

尝试使用\ n开始新行

回复于 2024-04-19T14:59:15+08:00

Google Apps脚本[电子邮件发送]

2 回答

相关问题