function emailToPCLaptopAndPhoneSuppliersFromLineManager() {

  function doGet(){

  }
  var EMAIL_SENT = "Email Has been sent";
  var spreadsheet = SpreadsheetApp.openById("1sMzCflZ-_MdHDdY4rAh03xJyeEuoN4TV2d1fxAKdNfQ");
  var sheet = spreadsheet.getSheetByName("Device Quotation");
  var startRow = 2;  // First row of data to process
  var numRows = 20000;   // Number of rows to process



  // Fetch the range of cells A2:B3
  var dataRange = sheet.getRange(startRow, 1, numRows, 40);

  // Fetch values for each row in the Range.
  var data = dataRange.getValues();
  for (var i = 0; i < data.length; ++i) {
    var row = data[i];
    var emailAddress = row[9];  // Suppliers emails
    Logger.log("loaded the emails")
    var htmlData = HtmlService.createTemplateFromFile('emailToPCLaptopAndPhoneSuppliersFromLineManager'); //html email content
    Logger.log("Loaded the template")
    //importing data from the google sheet


    htmlData.requestedDevices= row[1];
    htmlData.laptopQuantity= row[2];
    htmlData.desktopQuantity= row[3];
    htmlData.mobilePhoneQuantity= row[4];
    htmlData.tabletQuantity= row[5];
    htmlData.otherQuantities= row[6];
    htmlData.deviceSpecs= row[7];
    htmlData.requesterComments= row[8];
    htmlData.prefilledUrl= row[19];




    Logger.log("Loaded the data")
    var subject = "New Device Request ID "+row[1]+": Quotation Request ";
    var emailSent = row[20];
    Logger.log("Set the value of emailsent")
    if (row[1] !="" && emailSent != EMAIL_SENT) {  // Prevents sending duplicates
      //process only rows with data
      if (emailAddress != "") {
        MailApp.sendEmail(emailAddress,
                          subject,
                          'test', {                        // body
      htmlBody: htmlData.evaluate().getContent()                 // advanced options
    });
        sheet.getRange(startRow + i, 21).setValue(EMAIL_SENT);

        // Make sure the cell is updated right away in case the script is interrupted
        SpreadsheetApp.flush();
      }
    }
  }
}