cy6581
/ gist:f0ff3b2ed7f154a0a8e5168f44022478
Created
August 9, 2017 08:08
Simple Google Apps Script to export a single sheet to PDF and email it to a contact list
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Simple function to send Weekly Status Sheets to contacts listed on the "Contacts" sheet in the MPD. | |
| // Load a menu item called "Project Admin" with a submenu item called "Send Status" | |
| // Running this, sends the currently open sheet, as a PDF attachment | |
| function onOpen() { | |
| var submenu = [{name:"Send Status", functionName:"exportSomeSheets"}]; | |
| SpreadsheetApp.getActiveSpreadsheet().addMenu('Project Admin', submenu); | |
| } | |
| function exportSomeSheets() { |