title: Modify Code - Add a permanent CC to MailMerge - Google Sheets / Google Apps Script
body: <p>I would like to add a permanent CC to the below code. Code below works as intended.</p>
  
  <p>(CC someone@something.com) which I can place in any column in the spreadsheet with the other email addresses it is sending to.</p>
  
  <pre><code>function anothertestofamailmerge() {
  
  var Date  = 0;
  var NPOName = 2;
  var TotalBoxes = 3;
  var Email = 4;
  var Contact = 5;
  var SuggestedVehicle = 8;
  var Order = 9;
  
  var emailTemp = HtmlService.createTemplateFromFile("testofmailmerge");
  
  var ws = SpreadsheetApp.getActive().getSheetByName("MailMerge")
  
  var data = ws.getRange("A2:J" + ws.getLastRow()).getValues();
  
  data.forEach(function(row){
  
  emailTemp.Date  = row[Date ];
  emailTemp.NPOName = row[NPOName];
  emailTemp.TotalBoxes = row[TotalBoxes];
  emailTemp.Email = row[Email];
  emailTemp.Contact = row[Contact];
  emailTemp.SuggestedVehicle = row[SuggestedVehicle];
  emailTemp.Order = row[Order];
  
  var htmlMessage = emailTemp.evaluate().getContent();
  
  GmailApp.sendEmail(
    row[Email], 
    "Your Click &amp; Collect Order is READY to be collected!",                   
    "You Email",
    {name: "No Reply Warehouse", htmlBody: htmlMessage}
  );
  
  });
  </code></pre>
  
  <p>Thank you very much</p>