Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. function emailCurrentSheetAsPDF() {
  2. var ss=SpreadsheetApp.getActive();
  3. var sh=ss.getActiveSheet();
  4. var shts=ss.getSheets();
  5. for(var i=0;i<shts.length;i++) {
  6. if(shts[i]!=sh) {
  7. shts[i].hideSheet();
  8. }
  9. }
  10. var fldr=DriveApp.getRootFolder();
  11. var file=fldr.createFile(ss.getBlob().getAs('application/pdf'));
  12. GmailApp.sendEmail("bighillhelitack@gmail.com", "F-106", "Aircraft Dispatch".{attachments:[file]});
  13. file.setTrashed('true');
  14. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement