Good evening guys, I'm having a hard time putting a gap between cells like "A3: B18" in the body of the email in this code.
The script itself is running smoothly, only this range I do not know how to do.
// Envio de e-mail
function EnviarEmail() {
// Variáveis
var vplan = SpreadsheetApp.getActiveSheet();
var vparamail = "";
var vmsgmail = "";
var vassunto = "";
//Varre a lista de e-mails
//for (var i = 2; i < (vtotal+2); ++i){
//Recupera os valores
vparamail = vplan.getRange("B1").getValue();
vmsgmail = vplan.getRange("A4").getValue();
vplan.getRange("A4:B18").getValue();
vassunto = vplan.getRange("B2").getValue();
// Envia o e-mail
MailApp.sendEmail(vparamail, vassunto, vmsgmail);
Browser.msgBox('Email Enviado');
};