我一直试图编辑一个脚本,我必须大胆的某些文本。此脚本从Google表单电子表格中提取信息,并返回如下所示的电子邮件:
教师参与:在最初的观察中,教师有适当的参与(直接教学、建模、构建知识、指导/独立实践等)。
技术集成:没有技术使用或集成的证据
我希望标题“教师参与:”和“技术集成”是Bold,也许underlined.How我可以在我的代码中实现HTML吗?
我的代码是:
function sendEmail() {
var sheet = SpreadsheetApp.getActiveSheet();
var row = sheet.getActiveRange().getRowIndex();
var userEmail = sheet.getRange(row,
getColIndexByName("Username")).getValue();
var body = "Below are the results of a recent Walkthrough: ";
body += "\n\nTeacher Engagement: \n" + sheet.getRange(row,
getColIndexByName("Teacher Engagement")).getValue();
body += "\n\nTechnology Integration: \n" + sheet.getRange(row,
getColIndexByName("Technology Integration")).getValue();
MailApp.sendEmail(userEmail, subject, body, {name:"Classroom Walkthrough"});
}发布于 2015-07-28 15:38:42
用MailApp格式化电子邮件的唯一可行的解决方案是使用HTMLbody选项并将文本写成HTML。
例子:
function sendEmail() {
var sheet = SpreadsheetApp.getActiveSheet();
var row = sheet.getActiveRange().getRowIndex();
var userEmail = sheet.getRange(row,
getColIndexByName("Username")).getValue();
var body = "<HTML><BODY>"
+"Below are the results of a recent Walkthrough: "
+"<P>Teacher Engagement: <BR>"
+sheet.getRange(row,getColIndexByName("Teacher Engagement")).getValue()
+"</P>"
+"<P>Technology Integration: <BR>"
+sheet.getRange(row,getColIndexByName("Technology Integration")).getValue()
+"</P></BODY></HTML>";
MailApp.sendEmail({
to:userEmail,
subject:subject,
htmlBody:body,
name:"Classroom Walkthrough"
});
}结果:
Below are the results of a recent Walkthrough:
Teacher Engagement:
stuff
Technology Integration:
other stuffhttps://stackoverflow.com/questions/31663006
复制相似问题