我正在嘗試撰寫一個腳本來使用應用程式腳本發送郵件和 pdf 作為附件，但我不斷收到此錯誤
function sendEmails() {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2; // First row of data to process
var numRows = SpreadsheetApp.getActiveSheet().getRange('I1').getValue(); // getting number of rows by fetching value from a count function in sheet
var dataRange = sheet.getRange(startRow, 1, numRows, 2);
// Fetch values for each row in the Range.
var data = dataRange.getValues();
for (var i in data) {
var row = data[i];
var emailAddress = row[0]; // First column
var link = row[1];// Fetching ID by using mid fuction in sheet
var file = DriveApp.getFileById(link);
var subject = 'Sending emails from a Spreadsheet';
var htmlBody = DriveApp.getFileById("14KhceDa2lg7ojnwzFwpfiJCCx-xldPPj")
MailApp.sendEmail(emailAddress, subject, {htmlBody: htmlBody}, {attachments: [file[0].getAs(MimeType.PDF)]})
}
}uj5u.com熱心網友回復：
你只得到檔案物件使用DriveApp.getFileById所以file.getAs()直接使用，如下面的代碼所示
function sendEmails() {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2; // First row of data to process
var numRows = SpreadsheetApp.getActiveSheet().getRange('I1').getValue(); // getting number of rows by fetching value from a count function in sheet
var dataRange = sheet.getRange(startRow, 1, numRows, 2);
// Fetch values for each row in the Range.
var data = dataRange.getValues();
for (var i in data) {
var row = data[i];
var emailAddress = row[0]; // First column
var link = row[1];// Fetching ID by using mid fuction in sheet
var file = DriveApp.getFileById(link);
var subject = 'Sending emails from a Spreadsheet';
var htmlBody = DriveApp.getFileById("14KhceDa2lg7ojnwzFwpfiJCCx-xldPPj")
MailApp.sendEmail(emailAddress, subject, {htmlBody: htmlBody}, {attachments: [file.getAs(MimeType.PDF)]})
}
}uj5u.com熱心網友回復：
MailApp.sendEmail(emailAddress, subject, '',{htmlBody: htmlBody , attachments: [file.getAs(MimeType.PDF)]})
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/358789.html