title: How to format email from spreadsheet data using arrays?
body: <p>I am totally new to coding and I need some help on a bit of code. Here is my problem: I want to take many cells of data in a Google spreadsheet and send it in an email. I figured out how to pull the data into an email and the email sends, however, the data is only separated by commas and it is hard to distinguish. How can I make each cell's data appear on a separate line in the email? I believe I can do this with arrays, but as I said, I am new to this and I cannot figure out how to do it with what I have read so far. If you could provide an explanation, that would be greatly appreciated as well - this will, hopefully, keep me from asking the same question again and teach me. Thank you for your patience and help!</p>
  
  <pre><code>function emailData() {
  
  //Gather data from "Responses" sheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var responses = ss.getSheetByName("Form Responses");
  var lastRow = responses.getLastRow();
  var data = responses.getRange("A"+(lastRow)+":AK"+(lastRow));
  var values = data.getValues();
  
  //Gather email addresses from "Email" sheet (I have not gotten this far yet)
  var email = ss.getSheetByName("Email");
  var startRow = 2;
  var emailAdress = "email@email.com";
  var subject = "Capacity Campaign Contact Form";
  MailApp.sendEmail(emailAdress,subject,values);
  }
  </code></pre>