//AZ Script

function email() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var bulk = ss.getSheetByName("AZ");
  var lastrow = bulk.getLastRow();

  var data1 = bulk.getRange(6, 7, lastrow).getValues(); // part number column

  var report = ""
  var email ="";
  for(var i in data1){
    if(data1[i]!="") email += "<tr><td style='padding:5px'>" + data1[i];
  }

  report ="<table><tr><th>Part Number</th></tr>" + email + "</table>";

  MailApp.sendEmail(Session.getActiveUser().getEmail(),
                "Cycle Count", report, {htmlBody: report});
}

 ScriptApp.newTrigger("email")
   .timeBased()
   .onWeekDay(ScriptApp.WeekDay.THURSDAY)
   .create();

function myRecalculate() {

// The code below opens a spreadsheet using its ID
// Note that the spreadsheet is NOT physically opened on the client side.
// It is opened on the server only (for modification by the script).
var ss = SpreadsheetApp.openById("13SAt0XQgHQz1JRhXyvwbL6ASfnlLjvFXJQsHfYRM1nE");
var sheet = ss.getSheetByName("AZ");
var cell = sheet.getRange('G1')

cell.setValue("Randomizer!!!")
}

 ScriptApp.newTrigger("myRecalculate")
   .timeBased()
   .onWeekDay(ScriptApp.WeekDay.WEDNESDAY)
   .create();