title: Google Apps Script: sendEmail from sheet using cc and/or bcc, and avoid return of EMAIL_SENT to sheet
body: <p>I have a script that sends an email out to addresses on a sheet and then returns an entry in a column in the sheet that reads EMAIL_SENT. </p>
  
  <pre><code>function sendEmail()
  {
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2;
  var numRows = sheet.getLastRow();
  var EMAIL_SENT = "EMAIL_SENT";
  var dataRange = sheet.getRange(startRow, 1, numRows, 2000)
  var data = dataRange.getValues();
  for (var i = 0; i &lt; data.length; ++i) 
  {
  var row = data[i];
  var name = row [0].split(",")[1];
  var emailAddress = row [2]; 
  var Setting = Utilities.formatDate(new Date(row [2]), "CST", "MM-dd-YYYY");
  var Place = row [4];
  var emailSent = row[5];
  if (emailSent != "EMAIL_SENT")
  {  
  var message = "message body";
  var subject = "Email to Client";
  
  MailApp.sendEmail
  (emailAddress, subject, message,
  {htmlBody:message, 
  cc:'internalemail@internalemail.com'});
  
  sheet.getRange(startRow + i, 6).setValue(EMAIL_SENT);
  SpreadsheetApp.flush();  
  
  }}}
  </code></pre>
  
  <p>As you can see from the script, I am also wanting to cc a copy of the email to an internal email address, but avoid the return of the EMAIL_SENT to the sheet for this internal email. </p>
  
  <p>The script as written above sends two emails, but it does not seem to send the cc'd email to the internal email address, and it returns an instance of 'EMAIL_SENT' to the column in the source sheet. </p>