function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var sheet = ss.getSheetByName("Sheet7");
  var activerange = ss.getRange('B3');
  if (activerange='True')  MailApp.sendEmail("s......@gmail.com", "test mail", "Hi there");
}