Google Script -将活动工作表以PDF格式发送到单元格[2019]中列出的电子邮件

function sendPDFtoEmail() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var dataRange = sheet.getDataRange();
  var data = dataRange.getValues();
  
  for (var i = 1; i < data.length; i++) {
    var email = data[i][0];
    var pdfName = "活动工作表_" + i + ".pdf";
    
    // 生成PDF文件
    var pdf = DriveApp.getFileById(SpreadsheetApp.getActiveSpreadsheet().getId()).getAs('application/pdf').getBytes();
    
    // 发送邮件
    MailApp.sendEmail({
      to: email,
      subject: "活动工作表",
      body: "请查收附件中的活动工作表。",
      attachments: [{
        fileName: pdfName,
        content: pdf,
        mimeType: 'application/pdf'
      }]
    });
  }
}