Var userInterface=HtmlService.createHtmlOutputFromFile('Envelope').setWidth(300).setHeight(500).setTitle('Printing Envelopes') ĭocumentApp.getUi().showSidebar(userInterface) RetAddrStyle= ĭoc.getBody().appendParagraph('').setAttributes(retAddrStyle) ĭoc.getBody().appendParagraph(recaddr).setAttributes(retAddrStyle) įunction prepareEnvelope(retaddr,recaddr) Var recaddr=(typeof(recaddr)!='undefined')?recaddr:'No Recipient Address selected.' RetAddrStyle= ĭoc.getBody().getChild(0).asParagraph().setAttributes(retAddrStyle).setText(retaddr) Var retaddr=(typeof(retaddr)!='undefined')?retaddr:'No return address selected.' Return PropertiesService.getScriptProperties().getProperty('DSSID') Įnvelope10=296 Įnvelope10=684 Įnvelope10 = 'Calibri' Įnvelope10 = 14 Įnvelope10 = true Įnvelope10=1 ĭoc.getBody().clear().setAttributes(envelope10) Var props=PropertiesService.getScriptProperties() Var resp=DocumentApp.getUi().prompt('Mailing Address SpreadsheetId', 'Create a spreadsheet to store mailing address and enter the id of that spreadsheet here', DocumentApp.getUi().ButtonSet.OK) addItem('Show Envelope Sidebar', 'displayEnvelopeSidebar')įunction setupEnvelopeApp()//To make the connection between this document and the spreadsheet you created to store mailing addresses run this script from Script Editor Function makeEnvelopeMenu()//Rename this to onOpen if this is all you have in this documentĭocumentApp.getUi().createMenu('Envelope Tools')
0 kommentar(er)
