title: Is there any function in APPS Script that will allow me to email staff based on emails in a cell or range
body: <p>I'm trying to send an email from Google Sheets to update staff if they have filled a particular form out. The emails I need to be sent are sitting in the google sheet with the finish the form.</p>
  <p>If there are 5 emails in the sheet, I need a draught email sent to them with a link attached.</p>
  <p>I know you can send an email based on a value in a cell but I need an email sent to addresses that appear in the sheet.</p>
  <p><em><strong>Example</strong></em></p>
  <p>me@email.com</p>
  <p>you@email.com</p>
  <p>everyone@email.com</p>
  <p><em>SEND LINK</em></p>
  <p>The Apps Script needs to pick up those 3 emails and send the link I need them to receive.</p>