I am running the following code:
var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('FlowModelling');
var umail = activeSheet.getRange('H1').getValue();
Logger.log(SpreadsheetApp.getActiveSheet().getRange('H1').getValue())
var message = {
to: umail,
subject: "Flow Modelling & Pump Selection",
body: "Hi,\n\nPlease find the Flow Modelling & Pump Selection attached.\n\nThank you,\nAdmin at Watpump",
name: "Watpump",
attachments: [SpreadsheetApp.getActiveSpreadsheet().getAs(MimeType.PDF,).setName("Fluid Dynamics & Pump Selection")]
}
MailApp.sendEmail(message);
}
Everything works fine except the PDF pages don't scale to fit. In my document they are scaled to fit and do so if I do a manual PDF save. I have seen script for formatting Pdf's but do not know where to write the script (the + 'scale=4' seems appropriate??