Danielle McCarthy
1 min readJun 3, 2020

--

Ok, I just checked and this will work. instead of adding your email, add row[2] as the recipient if the emails are in column C. If they are in column D add row[3] and so on.

You can even add more than 1 recipient so if you want to send it to yourself as well as the email in the spreadsheet you could copy and paste and do something like below:

MailApp.sendEmail(row[2], subject, message);

MailApp.sendEmail(youremail@email.com, subject, message);

--

--

Danielle McCarthy
Danielle McCarthy

Written by Danielle McCarthy

Software Engineer, Virginian turned New Yorker, not a writer. Contact me @whatdanielle on Twitter & IG.

No responses yet