javascript - 我无法通过谷歌脚本发送带有 pdf 作为附件的电子邮件
问题描述
我正在制作一个获取电子表格的脚本,将其转换为 pdf 文件,然后将此 pdf 保存在文件夹中,然后通过电子邮件将其作为附件发送。但是,我正在使用我发现的唯一功能通过电子邮件发送附件,但是当我打开电子邮件时,它会在电子邮件中显示消息“[object Object]”。有人能帮我吗?
function SendEmail(){
var sheetMail = SpreadsheetApp.getActiveSpreadsheet();
var ecrvc = sheetMail.getSheetByName('List');
var planilha = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('List')
var
var subject = "Subject"
var message = "message"
var email = "person1@gmail.com"
//var ecrvc = "Sheet1";
var folderID = "folderId"; // Folder id to save in a folder.
var pdfName = "YourSpreadsheet of "+week+"-20";
var sourceSpreadsheet = SpreadsheetApp.getActive();
var sourceSheet = sourceSpreadsheet.getSheetByName(ecrvc);
var folder = DriveApp.getFolderById(folderID);
//Copy whole spreadsheet
var destSpreadsheet = SpreadsheetApp.open(DriveApp.getFileById(sourceSpreadsheet.getId()).makeCopy("tmp_convert_to_pdf", folder))
var destSheet = destSpreadsheet.getSheets()[0];
//save to pdf
var theBlob = destSpreadsheet.getBlob().getAs('application/pdf').setName(pdfName);
var newFile = folder.createFile(theBlob);
//Delete the temporary sheet
DriveApp.getFileById(destSpreadsheet.getId()).setTrashed(true);
//Send the email with attachments
var arquivo = theBlob;
DriveApp.getFileById(theBlob);
MailApp.sendEmail(email, subject,{
// htmlBody: message + "", noReply:true,{
attachments: [file.getAs.file(arquivo.PDF)],
name: pdfName
});
}
解决方案
有几个问题
file
未声明且getAs
语法错误。
// Send an email with two attachments: a file from Google Drive (as a PDF) and an HTML file.
var file = DriveApp.getFileById('1234567890abcdefghijklmnopqrstuvwxyz');
var blob = Utilities.newBlob('Insert any HTML content here', 'text/html', 'my_document.html');
MailApp.sendEmail('mike@example.com', 'Attachment example', 'Two files are attached.', {
name: 'Automatic Emailer Script',
attachments: [file.getAs(MimeType.PDF), blob]
});
推荐阅读
- json - 如何在flutter中访问json中的嵌套元素?
- python - Python“会议查找器”算法给出错误输出
- javascript - 格式化美国号码的输入字段
- windows - 带有计时器的Powershell删除项目?
- php - asset() 返回 //url... 而不是 http://url
- python - Pycups - 使用 IPPAttribute 创建和发送 IPPRequest 并解析响应(启用 IPP:Hold-New-Jobs)
- unity3d - 当浮点数在统一 2019.4.1f1 中返回 0 时混合树出现问题
- java - 如何在像古吉拉特语这样的java中打印印度地区语言?
- c# - 有什么方法可以基于 GetInstance() 动态转换类型
- c++ - SFML 无法加载图像