使用Google Script和Google Sheets的宏,可以在电子邮件中粘贴表格。下面是详细的步骤:
function sendEmailWithTable() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var range = sheet.getDataRange();
var data = range.getValues();
var emailBody = "<table>";
for (var i = 0; i < data.length; i++) {
emailBody += "<tr>";
for (var j = 0; j < data[i].length; j++) {
emailBody += "<td>" + data[i][j] + "</td>";
}
emailBody += "</tr>";
}
emailBody += "</table>";
MailApp.sendEmail({
to: "recipient@example.com",
subject: "表格数据",
htmlBody: emailBody
});
}
这样,你就可以使用Google Script和Google Sheets的宏,在电子邮件中粘贴表格数据了。
领取专属 10元无门槛券
手把手带您无忧上云