google-apps-script - 嘿,如何在电子邮件中将值 [1] 设为粗体,如何更改文本的颜色?
问题描述
这是脚本。我想知道如何添加粗体文本以及如何更改电子邮件中文本的颜色。我也有兴趣知道如何使用电子表格的原始格式将单元格直接拉入电子邮件中。
谢谢!
function myAlerts() { // this runs based on daily trigger
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Campaign List");
var range = sheet.getDataRange(); var values = range.getDisplayValues();
var lastRow = range.getLastRow();
var curDate = values[1][11];
var anyMatches = false;
var message = ""; var sheetUrl = ss.getUrl();
var email = Session.getActiveUser().getEmail();
var optionalEmail = values[2][12];
if (optionalEmail != "") { email = email + "," + optionalEmail; }
for (var i = 1; i < lastRow; i++) {
// if today matches the alert date, send an alert
if (values[i][5].toString() == curDate.toString()) {
// add a message for this row if date matches
message = message + values[i][1] + " will expire on " + values[i][5] + "<br />\n";
// if there is a match, set anyMatches to true so and email gets sent
anyMatches = true;
}
} // ends for loop
// footer for message
message = message + "<br />\nThis is an auto-generated email to remind you of your campaign expiration. <br />\n"
if (anyMatches) { // send an email
MailApp.sendEmail({
to: email,
subject: 'Campaign Expiration Notice!',
htmlBody: message});
}
}
解决方案
function myAlerts() {
var ss=SpreadsheetApp.getActiveSpreadsheet();
var sheet=ss.getSheetByName("Campaign List");
var range=sheet.getDataRange();
var values=range.getDisplayValues();
var lastRow=range.getLastRow();
var curDate=values[1][11];
var anyMatches=false;
var message="";
var sheetUrl=ss.getUrl();
var email=Session.getActiveUser().getEmail();
var optionalEmail=values[2][12];
if (optionalEmail!=""){
email+="," + optionalEmail;
}
for (var i=1;i<lastRow;i++) {
if (values[i][5].toString()==curDate.toString()) {
message+=Utilities.formatString('<strong>%s</strong> will expire on %s <br />\n"',values[i][1],values[i][5]);
anyMatches=true;
}
}
message+='<br />\n<font color="red">This is an auto-generated email to remind you of your campaign expiration.</font><br />\n'
if (anyMatches) {
MailApp.sendEmail({to: email,subject: 'Campaign Expiration Notice!',htmlBody: message});
}
}
推荐阅读
- julia - 为什么 Julia 中的循环会引入自己的作用域
- apache-kafka - kafka 主题中推荐的消息长度
- ruby-on-rails - “安装 puma (3.4.0) 时出错”
- google-analytics - Google Analytics(分析)在特定页面之后访问的平均页面数
- react-native - 滚动隐藏标题在本机反应中不能按需要工作
- docker - 通过 Docker Compose 的 Docker Volume 问题
- wordpress - 如何使用 wordpress 流利形式自定义进度条?
- mysql - 在 Mac 上运行 mysql 时,ERROR COLLATION 'utf8_unicode_ci' 对 CHARACTER SET 'utf8mb4' 无效
- python - AttributeError 疑难解答:“NoneType”对象没有“发送”属性
- javascript - 是否可以从消息中获取图像并将其添加到 Discord.js 的文件夹中?