function sendMail(){
 var sh = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("SEPARATE REPORT");
 var data = sh.getRange("Q2:T3").getValues();
  //var htmltable =[];
  var emailAddress = "ashwani.kumar1@meenakshipolymers.com";
  var subject = "GURGAON PRODUCTIVITY REPORT";
  

  var tableFormat = 'cellspacing="50" cellpadding="6" dir="ltr" border="30" style="width:100%;table-layout:fixed;font-size:12pt;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;Cell:Merge Cell'
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>' + '' + '</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({
       to: "vijaya.budhiraja@meenakshipolymers.com,sanjeevsoni@meenakshipolymers.com,sakshi.kapoor@meenakshipolymers.com,bijender.singh@meenakshipolymers.com,ashwani.kumar1@meenakshipolymers.com",
         subject:" GURGAON PRODUCTIVITY REPORT" ,
         htmlBody: htmltable
  })
}