代码之家  ›  专栏  ›  技术社区  ›  Mr. M. Perzan

附件未随电子邮件一起发送-GScript

gmail-api google-apps-script pdf
  •  1
  • Mr. M. Perzan  · 技术社区  · 7 年前 

     function SendEmailsOnBirthday() {

 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheetBirthDay = ss.getSheetByName('StudentImport');
 var holder = sheetBirthDay.getRange("A2:K1501").getValues();

 //folder holding birthday pictures
 var folderID = DriveApp.getFolderById("0Bw-NxCTsRPcScnRLb29iZ2tqSEU");

 var Today = new Date();
 var TodayMonth = Today.getMonth();
 var TodayDay = Today.getDay();

//make an array of all the picture file IDs
 var Files = folderID.getFiles();
 var FileList = [];
 while (Files.hasNext()){
   var file = Files.next();
   var FileID = file.getId();
   FileList = FileList.concat([FileID]);
   }

for (i in holder){
  var RandomPicture = Math.floor(Math.random() * FileList.length);

  if (holder[i][10].indexOf("@")>-1){
  //check for month and day!
  var BirthDate = holder[i][7];
  var BirthMonth = BirthDate.getMonth();
  var BirthDay = BirthDate.getDay();
  if (TodayMonth === BirthMonth && TodayDay === BirthDay){
  var First = holder[i][1];
  var Last = holder[i][0];
  var Email = holder[i][10];

  var pdf = DriveApp.getFileById(FileList[RandomPicture]).getAs("application/pdf");

  var subject = "Happy Birthday Fellow Falcon!";
  var body = "We just wanted to wish you a happy birthday from the St. Ignatius Staff and Students!";


   MailApp.sendEmail(Email, subject, body, {noReply: true, attachements: pdf});



}}}}

    这是日志文件。。。。如果有帮助: 

    [17-10-20 09:04:20:454 EDT] Starting execution
[17-10-20 09:04:20:462 EDT] SpreadsheetApp.getActiveSpreadsheet() [0 seconds]
[17-10-20 09:04:20:525 EDT] Spreadsheet.getSheetByName([StudentImport]) [0.063 seconds]
[17-10-20 09:04:20:595 EDT] Sheet.getRange([A2:K1501]) [0.069 seconds]
[17-10-20 09:04:20:665 EDT] Range.getValues() [0.069 seconds]
[17-10-20 09:04:20:871 EDT] DriveApp.getFolderById([0Bw-NxCTsRPcScnRLb29iZ2tqSEU]) [0.199 seconds]
[17-10-20 09:04:20:872 EDT] Folder.getFiles() [0 seconds]
[17-10-20 09:04:21:464 EDT] FileIterator.hasNext() [0.591 seconds]
[17-10-20 09:04:21:465 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:465 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:465 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:466 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:466 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:466 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:467 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:467 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:467 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:468 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:468 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:468 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:469 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:469 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:469 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:470 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:470 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:470 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:471 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:471 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:471 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:471 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:472 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:472 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:472 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:472 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:472 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:473 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:473 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:473 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:474 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:474 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:474 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:474 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:474 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:475 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:475 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:475 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:475 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:476 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:476 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:476 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:477 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:477 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:477 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:477 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:477 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:478 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:478 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:478 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:478 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:479 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:479 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:479 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:480 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:480 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:480 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:480 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:480 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:481 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:481 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:481 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:481 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:482 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:482 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:482 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:483 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:483 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:483 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:483 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:483 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:484 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:484 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:484 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:484 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:485 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:485 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:485 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:486 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:486 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:486 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:486 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:487 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:487 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:487 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:487 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:487 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:488 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:488 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:488 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:489 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:489 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:489 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:490 EDT] FileIterator.next() [0 seconds]
[17-10-20 09:04:21:490 EDT] File.getId() [0 seconds]
[17-10-20 09:04:21:490 EDT] FileIterator.hasNext() [0 seconds]
[17-10-20 09:04:21:641 EDT] DriveApp.getFileById([0Bw-NxCTsRPcSNW5nZXRRWXVYMnM]) [0.151 seconds]
[17-10-20 09:04:21:642 EDT] File.getAs([application/pdf]) [0 seconds]
[17-10-20 09:04:21:685 EDT] MailApp.sendEmail([mperzan@tbcschools.ca, Happy Birthday Fellow Falcon!, We just wanted to wish you a happy birthday from the St. Ignatius Staff and Students!, {noReply=true, attachements=[Blob]}]) [0.041 seconds]
[17-10-20 09:04:22:304 EDT] DriveApp.getFileById([0Bw-NxCTsRPcSUUdaYWFCU19DSHc]) [0.618 seconds]
[17-10-20 09:04:22:304 EDT] File.getAs([application/pdf]) [0 seconds]
[17-10-20 09:04:22:337 EDT] MailApp.sendEmail([mperzan@tbcschools.ca, Happy Birthday Fellow Falcon!, We just wanted to wish you a happy birthday from the St. Ignatius Staff and Students!, {noReply=true, attachements=[Blob]}]) [0.032 seconds]
[17-10-20 09:04:22:382 EDT] Execution succeeded [1.919 seconds total runtime]
    1 回复  |  直到 7 年前
        1
  •  1
  •   Tanaike    7 年前

    似乎从您添加的日志中,检索您要发送的文件blob是可行的。那么下面的修改怎么样?

    发件人:

    从您添加的日志中,您当前的脚本似乎在下面。 

    MailApp.sendEmail([Email, subject, body, {noReply=true, attachements=[Blob]}])


    MailApp.sendEmail({
  to: Email,
  subject: subject,
  body: body,
  noReply: true,
  attachments: [pdf]
});

    参考:

    • MailApp.sendEmail() 是 here .

    如果这不起作用,我很抱歉。

    推荐文章
    Bumboobee  ·  有没有办法将Pdf放入Swal模型中?
    2 年前
    Bakare Kazeem  ·  如何使用node将图像转换为PDF。没有第三方Api的js
    2 年前
    Karma  ·  PHP致命错误:未捕获错误:在C:\xampp\htdocs\server\pdf中找不到类“Mpdf\Mpdf”。菲律宾:5
    2 年前
    WhiteWolf  ·  PDFJsAnnotations Uncaught(承诺中)语法错误:JSON输入意外结束
    2 年前
    Madal Africa-Guinea  ·  如何使用Itext7有效减少PDF大小?
    2 年前
    Vik G  ·  R中PDF中的额外字体
    6 年前
    Penachia  ·  PDF FontDescriptor标志
    6 年前
    Koosh  ·  PDF文档的页数不一致
    6 年前
    Nicholas Farmer  ·  Xcode PDFKit表单自动计算
    6 年前
    Juan Antonio  ·  pdftk-使用FDF自动填充PDF表单
    6 年前
    关于   移动版
    代码之家 - 一站式码农服务社区
    沪ICP备11025650号