Using cc in Gmail.App

[Paul Cook]

Does Gmail.Ap allow an email address to be cc'd in? If so how would I get this to work?

[Paul Cook]

I tried this but it doesn't work and just sends to the to email which is recipient

//Create function to send email with link to gsheet on regular basis

  function sendUpdateEmail() {

//include link to sheet within ''

  var sheetUrl = 'https://docs.google.com/spreadsheets/d/1BKdZKF3TSlil-xDiYKns4GYhehPezj9wN6UIeVDPzCM/edit#gid=0';

//include recipient email addresses within '' separated by ,

  var recipients = 'email';

  var cc = 'email';

  var subject = 'This is a test email to automate sending gsheets';

  var body = 'Dear all,\n\nThis is a test email to automate sending gsheets:\n\n' + sheetUrl + '\n\nThank you!\n\nKind regards,\nPaul';

 

// Send email to recipients

  GmailApp.sendEmail(recipients, cc, subject, body);

}

[Scott Bennett]

Here is the documentation. 

Scott Bennett

Sent from my iPhone 

On Aug 12, 2023, at 8:45 AM, 'Paul Cook' via Google Apps Script Community <google-apps-sc...@googlegroups.com> wrote:

I tried this but it doesn't work and just sends to the to email which is recipient

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/33312e93-29dc-47f5-87c4-693ffa990f46n%40googlegroups.com.

[cbmserv...@gmail.com]

Try this:

 

     GmailApp.sendEmail(recipients, subject, body, {cc: cc});

--

[Paul Cook]

perfect that worked thanks! why does it have to be in {}

[CBMServices Web]

The curly brackets is representing an object which are the options to be used. So inside the brackets you can put all the various options you want to specify. For example if you want to use an html version of the message body, you would then specify it there.

Check out the full list of options you can use from the reference link that was sent to you.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/c464435f-ad71-4fb6-94d4-da65c6cf1617n%40googlegroups.com.