function emailMe() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Form Responses 1');
  var height = sheet.getDataRange().getHeight();
  var lastEntry = sheet.getRange(height, 2).getValue().trim().toLowerCase();
  if (lastEntry == 'yes') {
    var subject = 'Someone said yes';
    var body = sheet.getRange(height, 1, 1, 10).getValues()[0].join('n');
    GmailApp.sendEmail('youremail@gmail.com', subject, body);
  }
}

GmailApp.sendEmail('youremail@gmail.com', subject, body, {cc: 'first@aol.com,second@yahoo.com'});