我在Google应用程序脚本中有此代码,可以在Google表单完成后自动接收电子邮件,但是我尚无法编辑样式。我尝试过的内联样式不起作用。我想添加一张桌子,更改我的字体甚至颜色。
代码:
function formSubmitReply(e) {
var alUser = e.values[1];
var entity = e.values[3];
var language = e.values[2];
var category = e.values[4];
var title = e.values[5];
var questions = e.values[6];
var attach = e.values[7];
var entityEn = e.values[8];
var categoryEn = e.values[9];
var titleEn = e.values[10];
var questionsEn = e.values[11];
var attachEn = e.values[12];
var userEmail = "[email protected]" + "," + "[email protected]";
var msgFr = "<p>You have received a new inquiry</p>" +
"<h4>AL user: </h4>" + alUser +
"<h4>Entité </h4>" + entity +
"<h4>Langue préférée: </h4>" + language +
"<h4>Catégorie de la demande: </h4>" + category +
"<h4>Titre de la demande: </h4>" + title +
"<h4>Contenu de la demande </h4>" + questions + "<br>" +
"<h4>Ajouter: </h4>" + attach + "<br>";
var msgEn = "<p>You have received a new inquiry</p>" +
"<h4>AL user: </h4>" + alUser +
"<h4>Entity: </h4>" + entityEn +
"<h4>Preferred Language: </h4>" + language +
"<h4>Category: </h4>" + categoryEn +
"<h4>Title: </h4>" + titleEn +
"<h4>Question: </h4>" + questionsEn + "<br>" +
"<h4>Attachments: </h4>" + attachEn + "<br>";
MailApp.sendEmail({
to: userEmail,
subject: 'NAM HR Mailbox | ' + category,
htmlBody: (language=="English") ? msgEn : msgFr
});
}
如果要在表格中显示表格,则需要正确设置表格的样式。尝试添加一个示例表,更改字体和颜色:
var msgEn =
"<p>You have received a new inquiry</p>" +
// Add table style and format the cells with th and tr
"<table border='1' style='border-collapse:collapse'>" +
"<tr>" +
"<th>AL user:</th>" +
// Add font style
"<th style='font-family:courier;'>Entity:</th>" +
"<th>Preferred Language:</th>" +
"<th>Category:</th>" +
"<th>Title:</th>" +
"<th>Question:</th>" +
"<th>Attachments:</th>" +
"</tr>" +
"<tr>" +
"<td>" + alUser + "</td>" +
// Add font color
"<td style='color:red;'>" + entityEn + "</td>" +
"<td>" + language + "</td>" +
"<td>" + categoryEn + "</td>" +
"<td>" + titleEn + "</td>" +
"<td>" + questionsEn + "</td>" +
"<td>" + attachEn + "</td>" +
"</tr>" +
"</table>";
如您所见,我将列的字体和颜色Entity
分别编辑为courier和red
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句