function sendMail(){
  var sh = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sh.getRange("A2:O38").getValues();
  //var htmltable =[];

  var TABLEFORMAT = 'cellspacing="2" cellpadding="2" dir="ltr" border="1"style="width:100%;table-layout:fixed;font-size:10pt;font-family:arial,sans,sans-serif;border-collapse:collapse;border:1px solid      #ccc;font-weight:normal;color:black;background-color:white;text-      align:center;text-decoration:none;font-style:normal;'
  var htmltable = '<table ' + TABLEFORMAT +' ">';

   for (row = 0; row<data.length; row++){

    htmltable += '<tr>';

   for (col = 0 ;col<data[row].length; col++){
   if (data[row][col] === "" || 0) {htmltable += '<td>' + 'None' + '</td>';}
   else
    if (row === 0)  {htmltable += '<th>' + data[row][col] + '</th>';
    }

    else {htmltable += '<td>' + data[row][col] + '</td>';}
    }

         htmltable += '</tr>';
    }

     htmltable += '</table>';
     Logger.log(data);
     Logger.log(htmltable);
     MailApp.sendEmail(Session.getActiveUser().getEmail(), 'Daily report','' ,{htmlBody: htmltable})