mardi 6 octobre 2020

GmailApp per email recipient quota or how can I test GmailApp code without sending an email to 50+ people?

Google's quota for recipients per email is unclear. It says 50 here. It says 100, here.

My current code uses MailApp and indeed it seems to fail with over 50 bcc'd:

function sendEmail(form) {
  
  var ss = SpreadsheetApp.getActive();
  var body = form.body;
  var bcc = form.bccfield;
  var cc = form.ccfield;
  var to = form.tofield;
  var subject = form.subject;
   var eHandle = ss.getSheetByName("Email Handling");
  var sig = eHandle.getRange(10, 2).getValue();
  var img = eHandle.getRange(11, 2).getValue();    
  var sigImage = '<img src ="' + img + '" >';
  
MailApp.sendEmail({
    to: to,
  cc: cc,
  bcc: bcc,
    subject: subject,
   
  htmlBody: body.replace(/\n/g, '<br>') + sig + sigImage});
  }

I am considering switching to using GmailApp per the suggestion here.

Will that get me up to the 100? A user here suggested maybe but it doesn't seem resolved.

I would test it myself but how can I do that without actually trying to send an email to more than 50 people?

Aucun commentaire:

Enregistrer un commentaire