Google APPSCRIPT: How do I send additional email addresses as a bcc and have them all in 1 box (google sheets) separated by commas?

Viewed 13

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!

0 Answers
Related