title: “Limit Exceeded: Email body size” when sending htmlBody
body: <p>I am using this google script to send excell sheet in mail without changing its format but when the file is large it shows Limit Exceeded: Email Body Size. </p>
  
  <pre><code>// Refer to this link for installation: https://sites.google.com/site/scriptsexamples/custom-methods/sheetconverter
  function convSheetAndEmail(rng, email, subj)
  {
    var HTML = SheetConverter.convertRange2html(rng);
  //  Logger.log("theSheetContents: " + HTML);
  //  MailApp.sendEmail(email, subj, '', {htmlBody : HTML});
    MailApp.sendEmail({
       to: email,
       subject: subj,
       htmlBody: HTML});
  }
  function doGet()
  {
    // or Specify a range like A1:D12, etc.
    var sheetName = "Sheet1";
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getSheetByName(sheetName);
    var dataRange = sheet.getDataRange();
    Logger.log("theSheetContents: " + dataRange);
    var emailUser = '***@.com';
    var subject = 'PSR';
    convSheetAndEmail(dataRange, emailUser, subject);
  }```
  
  
  
  </code></pre>