防止使用MailApp进行文本换行。发送电子邮件谷歌表单？谷歌脚本

Question

我有以下工作代码，可以根据一个单元格的内容发送电子邮件。此单元格包含用于创建电子邮件的其他单元格的值。

电子邮件发送给2个收件人，效果良好。但是，在收到电子邮件后，文本将在74个字符后包装。

样本表副本发布：https://docs.google.com/spreadsheets/d/1PDSHbrhxiJliTGNx2rlJRAJIrjITADVuGWqTuvpjrgw/edit?usp=sharing

如何防止包装？我想发送的电子邮件，因为它出现在'body'单元格：

=G2&char(10)&E9&char(10)&E10&char(10)&E11&char(10)&E12&char(10)&E13&char(10)&E14&char(10)&E15&char(10)&E16&char(10)&E17&char(10)&E18&char(10)&E19&char(10)&E20&char(10)&E21&char(10)&E22&char(10)&E23&char(10)&E24&char(10)&E25&char(10)&E26&char(10)&E27&char(10)&E28&char(10)&E29&char(10)&E30&char(10)&E31&char(10)

发送邮件功能：

var EMAIL_SENT = 'EMAIL_SENT';

function SendEmailACC() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("EmailACC");
  var startRow = 2; 
  var numRows = 2; 
  var dataRange = sheet.getRange(startRow, 1, numRows, 6); 
  var data = dataRange.getValues(); 
  for (var i = 0; i < data.length; ++i) {
    var row = data[i];
    var emailAddress = row[0]; // First column
    var message = row[1]; // Second column
    var subject = row[2]; 
    var emailSent = row[5]; 
    var EMAIL_SENT = "Email Processed";
    var EMAIL_FAIL = "Email Not Sent";
    if (emailSent !== EMAIL_SENT) { 

      MailApp.sendEmail(emailAddress, subject, message);
      sheet.getRange(startRow + i, 5).setValue(EMAIL_SENT);
      SpreadsheetApp.flush();

    }
  }
  Utilities.sleep(3000);// pause in the loop
  DeleteStatus();
}

示例电子邮件的外观：

Good Morning,

The following claim may have had an incorrect or missing ACC number or was not submitted by the referrer at time of request.
The claim has since been amended or submitted for the release of $50. Updated details are as below.

Vendor ID: ABC123
Invoice number: ABCDE12345
Service Date: 11/10/2019
Patient: John Smith
Service Code(s): COD88
First supplied ACC Number: BTT123
Exam Type: Exam Abc

Amended or updated ACC Number: COD123

Please let me know if any further information is required.

电子邮件的实际输出方式：

Good Morning,

The following claim may have had an incorrect or missing ACC number or was 
not submitted by the referrer at time of request.
The claim has since been amended or submitted for the release of $50. 
Updated details are as below.

Vendor ID: G0A368
Invoice number: ABCDE12345
Service Date: 11/10/2019
Patient: John Smith
Service Code(s): COD88
First supplied ACC Number: BTT123
Exam Type: Exam Abc

Amended or updated ACC Number: COD123

Please let me know if any further information is required.

有什么建议吗

Answer 1

这个答案怎么样？请把这看作是几个可能的答案之一。

在这个模式中，使用了类GmailApp。

MailApp.sendEmail(emailAddress, subject, message);

GmailApp.sendEmail(emailAddress, subject, message);

在此模式中，使用Gmail API。在这种情况下，请在高级Google服务中启用Gmail API。

MailApp.sendEmail(emailAddress, subject, message);

var raw = Utilities.base64EncodeWebSafe("Subject: " + subject + "\r\n" + "To: " + emailAddress + "\r\n" + "Content-Type: text/plain; charset=UTF-8\r\n\r\n" + message + "\r\n\r\n");
Gmail.Users.Messages.send({raw: raw}, "me");

• 如果电子邮件中包含超过Unicode 6.0版本的字符，则需要使用Gmail API。请小心这个。参考号

• 根据我的经验，我也有同样的问题。当时，这个问题可以通过使用GailApp类来解决。但不幸的是，我在官方文件中找不到对此的详细解释。我为此道歉。

• MailApp。发送电子邮件（收件人、主题、正文）
• GmailApp。发送电子邮件（收件人、主题、正文）
• 高级谷歌服务
• Gmail API