添加多个附件的Gmail
问题描述:
我使用的是谷歌电子表格,并希望多个附件发送给我们的客户,无论怎样我格式化被拒绝或只有一个附件发送的代码,任何人都可以在这方面帮助,请添加多个附件的Gmail
function emailcustomer() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("email to customer")
var subject = sheet.getRange("B2").getValue()
var content = sheet.getRange("A12").getValue()
var doc1 = sheet.getRange("d28").getValue()
var doc2 = sheet.getRange("d29").getValue()
var file1 = DocsList.getFileById(doc1);
var file2 = DocsList.getFileById(doc2);
GmailApp.sendEmail("[email protected]",subject,content,{attachments:file1 file2});
}
答
你可以尝试这样的事:
var myFiles = [{fileName:"doc1", content:file1}, {fileName:"doc2", content:file2}]
GmailApp.sendEmail("[email protected]", subject,content, {attachments: myFiles});
而且,这也许可以帮助:https://developers.google.com/apps-script/class_gmailapp#sendEmail
答
你需要指定阿塔的MIME类型chment然后将其添加到您的数组:
var attachments = [];
attachments.push(file.getAs(MimeType.PDF));
GmailApp.sendEmail(email, subject, body,{
attachments: attachments,
});
感谢您的建议,我肯定会尝试这个 – user1571606 2012-08-03 06:13:06
我曾尝试你的第一个建议,但我得到这个消息“附件内容无法辨识为字串或二进制” – user1571606 2012-08-03 08:58:23
感谢您的提示,我最终通过使用以下代码来解决一些问题,最终得以实现:var myFiles = [file1,file2] GmailApp.sendEmail(“[email protected]”,subject,content, {附件:MYFILES}); – user1571606 2012-08-03 09:12:02