如何使用(GAS)在Google中断线

Question

你好，我是Google应用程序脚本的新手。我有一个包含6列和1行的google工作表，一旦我可以运行它，就会插入更多的

我的目标是从我的第一栏的电子邮件列表中自动发送电子邮件。使用第2-6栏的电子邮件中的文本，我设法发送了电子邮件，但它把所有的邮件混合在一起。

有谁知道该怎么写才能让一封普通的电子邮件显示每一列的下一行，并在列前添加类似“你的学生”这样的文字呢？

这就是我所拥有的

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2;  // First row of data to process
  var numRows = 1;   // Number of rows to process
  // Fetch the range of cells A1:F2
  var dataRange = sheet.getRange(startRow, 1, numRows, 5)
  // Fetch values for each row in the Range.
  var data = dataRange.getValues();
  for (i in data) {
  var row = data[i];
  var emailAddress = row[0];  // First column
  var message = "Hello your Student" + row[1] 
    **" Has done a marvelous job in Class" + row[2]
    " His new area to grow involves" + row[3]+ row [4]+ row [5] ;**
  var subject = "Report for your Student";
  MailApp.sendEmail(emailAddress, subject, message);

}}

在电子邮件中看不到明星，也许是因为它在下一行，我不知道该怎么写才能让它继续运行，并在电子邮件中使用一个空格。谢谢

Answer 1

var message = "Hello your Student" + row[1] 
     + " Has done a marvelous job in Class" + row[2]
     + " His new area to grow involves" + row[3]+ row [4]+ row [5] ;

或者如果你需要换行

var message = "Hello your Student" + row[1] + '\n'
     + " Has done a marvelous job in Class" + row[2] + '\n'
     + " His new area to grow involves" + row[3]+ row [4]+ row [5] ;

Answer 2

使用html，您可以添加中断和或其他格式，如Bold。

​

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2;  // First row of data to process
  var numRows = 1;   // Number of rows to process
  // Fetch the range of cells A1:F2
  var dataRange = sheet.getRange(startRow, 1, numRows, 5)
  // Fetch values for each row in the Range.
  var data = dataRange.getValues();
  for (i in data) {
  var row = data[i];
  var emailAddress = row[0];  // First column
    var myMessage = "<b>Hello your Student</b> " + row[1] + " <br> Has done a marvelous job in Class" + row[2] + "<br> His new area to grow involves:" + "<br>" + row[3] + "<br>" + row [4] + "<br>" + row [5] ;
  var subject = "Report for your Student";
    MailApp.sendEmail(emailAddress, subject, 'text Body',{htmlBody: myMessage});
  }}

​