Generation

generate functionWed, 22 Mar 2023

scrip para enviar como imagen o pdf un rango de celdas de google sheet a este correo carlos79352@gmail.com y a este miguel.rodriguez@envases.mx

function enviar_mail() { var subject = "Reporte de facturacion"; var body = "Reporte de facturacion enviado desde google sheet"; var sheet = SpreadsheetApp.getActiveSheet(); var range = sheet.getRange(1, 1, sheet.getLastRow(), sheet.getLastColumn()); var data = range.getValues(); var attach = range.getA1Notation() + "!" + range.getSheet().getName() + ".pdf"; var to = "carlos79352@gmail.com,miguel.rodriguez@envases.mx"; var cc = "carl@lonelydolphin.net"; MailApp.sendEmail({ to: to, cc: cc, subject: subject, htmlBody: body, attachments: [{ fileName: attach, content: data }] }); }

Javascript
Generate More

Questions about programming?Chat with your personal AI assistant