0
votes

i want to write a script where I can send an email where the body will be the a cell value from the sheet

function sendemail()  {
MailApp.sendEmail("email address", "subject", "body");
}

the above code work but the only issue I'm facing to make "body" refer to the Cell from where data will be copied