Hello thank you for your help in advanced. This is the first script I have written since Hello World in 6th grade.
I have created a script that gathers information from google sheets
Currently I only have 1 column for the main Email send. lets call it [Email]
Is it possible for me to create a second email column lets call it [Email2]
I would like Email2 to have a 0-4 additional emails. lets call it 1@msn.com, 2@msn.com, 3@msn.com 4@msn.com
Is it possible to generate those emails (in 1 data box, not sure the name for those things,) into multiple emails. Actually now that I am writing this out I realize that I just need to gather all the information in the (cell?) thing and send it to the bcc part of the email function.
This is what I am using to generate the email line of the email:
data.forEach(function(row){
var htmlMessage = emailTemplate.evaluate().getContent();
GmailApp.sendEmail(
row[Email],
Thank you!
Coding is fun!