0

I need to know how to convert a sheet of the same drive in to an excel archive and send it. I don't want in PDF, the code is just an example.

function SendEmailWithCC(){

  SpreadsheetApp.getActiveSpreadsheet().getSheetByName("BD").hideSheet();
  SpreadsheetApp.getActiveSpreadsheet().getSheetByName("LISTA").hideSheet();
  SpreadsheetApp.getActiveSpreadsheet().getSheetByName("PLANTILLA").hideSheet();
  var plantilla = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("PLANTILLA");  
  var plantilla1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("PLANTILLA").getRange("A1").getValue();    
  var plantilla2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("PLANTILLA").getRange("A3").getValue();    
  var recipient = plantilla.getRange("E2").getValue();
  var fecha2 = plantilla.getRange("E5").getValue();
  var fecha = plantilla.getRange("E3").getValue();
  var nombre = plantilla.getRange("E1").getValue();

  var subject = plantilla1.replace("{Fecha2}", fecha2);
  var body = plantilla2.replace("{NombreCompleto}", nombre)
                  .replace("{Fecha}", fecha);

  var options = {
  cc: "example.email@xxx.yy",
  attachments: [SpreadsheetApp.getActiveSpreadsheet().getAs(MimeType.PDF).setName("Archivo de ajustes")]
                }
  MailApp.sendEmail(recipient, subject, body, options);
                           }
Rubén
  • 29,320
  • 9
  • 61
  • 145
SebasE
  • 1

0 Answers0