Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function emailCurrentSheetAsPDF() {
- var ss=SpreadsheetApp.getActive();
- var sh=ss.getActiveSheet();
- var shts=ss.getSheets();
- for(var i=0;i<shts.length;i++) {
- if(shts[i]!=sh) {
- shts[i].hideSheet();
- }
- }
- var fldr=DriveApp.getRootFolder();
- var file=fldr.createFile(ss.getBlob().getAs('application/pdf'));
- GmailApp.sendEmail("bighillhelitack@gmail.com", "F-106", "Aircraft Dispatch".{attachments:[file]});
- file.setTrashed('true');
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement