add cc and bcc while sending confirmation mail from google forms


I want to know the script to send the auto mail confirmation to multiple email is’s . pfb code and correct it if it’s wrong .

/* Send Confirmation Email with Google Forms */

function Initialize() {

var triggers = ScriptApp.getScriptTriggers();

for (var i in triggers) {



function SendConfirmationMail(e) {

try {

var to, ss, bcc, cc, sendername, subject, columns;
var message, value, textbody, sender;

bcc = “”
// This is your email address and you will be in the CC
cc = Session.getActiveUser().getEmail();

// This will show up as the sender’s name
sendername = “EAT Ticket System”;

// Optional but change the following variable
// to have a custom subject for Google Docs emails
subject = “EAT Ticket System”;

// This is the body of the auto-reply
message = “We have received your details.


ss = SpreadsheetApp.getActiveSheet();
columns = ss.getRange(1, 1, 1, ss.getLastColumn()).getValues()[0];

// This is the submitter’s email address
sender = e.namedValues["Ticket Raised by"].toString();

to = e.namedValues["To"].toString();

// Only include form values that are not blank
for ( var keys in columns ) {
var key = columns[keys];
if ( e.namedValues[key] ) {
message += key + ‘ :: ‘+ e.namedValues[key] + “

textbody = message.replace(“
“, “\n”);

GmailApp.sendEmail(to,bcc, sender, subject, textbody,
{To: to, bcc:bcc, cc: cc, name: sendername, htmlBody: message});

} catch (e) {


Thanks & Regards,
Irshad .

    Save tweets with pictures using a hashtag

    I am loving the archiver script but wanted a list of appropriate operators to use on the search function. Ideally I want to grab all searched hashtags that also include pictures. Ideas?

      Mail Merge – fails to pick up “First Name” to all recipients


      Some of my colleagues have had a problem with the mail merge. Their merge fields and column headers are correct but after a certain number have been merged, the email continues to send to all the addresses in the spreadsheet but only picking up on one “First Name” eg sending 100 emails correctly and then the next 100 will all say “Hi Mike” regardless of the corresponding name in the column…which is obviously a bit embarrassing.

      Do you have any tips on how to avoid this?


        Highly Compressed – fake or working

        Hello Amit Sir,
        I would like to know – is “highly compress” things really work or it’s just a fake think. I have downloaded many highly compressed things but none of them worked so I think that I should ask more guys to know if highly compressed is a fake think.
        Regards: –

          mail merge in gmail

          Last spring I looked up how to do a mail merge with gmail and I was successful. Now I am trying it again, and it seems there is a new way to do it. however, there are some features that don’t seem to be available in the new program. For example I want to personalize my emails with info and variables in the body of the email. before I was able to write an email in gmail, with variable notations ($%business name% ) in the body of the email. then in my googledoc I matched the column headers to those variables. How can I do that with your new version?

            music streaming service

            hello sir,
            how free music streaming services are working?Do need any copyright rights to do music streaming?

              Images not Saved

              I just stared using your script to automatically save attachments to my GD. Everything works fine and all the attachments are saved EXCEPT jpg files.

              In Gmail, all the emails with attachments get the label processed (including emails with pictures as attachments) but images do not show in GD.

              Any feedback will be much appreciated.

              Thanks you,

              I changed label from inbox to all and it saved images from other emails (including jpg) but some are still not being saved.

              What I noticed is:
              1. In emails where images were saved, pictures show as attachments;
              2. In emails where images were not saved, when I open the email I just see the pics (pics show, not listed as attachments.

                Group email help

                I am studying in college..I want help to create group email..means when one faculty member send email to one particular email id then it must be received by all the students at their personal email address..
                Reply me as soon as possible..
                Thank you..