MailApp.sendEmail

[Kevin Corcoran]

Hello, Can someone please help me figure out why my script for  MailApp.sendEmail has worked flawlessly for several years and just in the past few days it's stopped sending the email? I edited it to have the email go to myself and it worked again but using the old email address as well as two other emails in our office we get nothing.

Are there any known issues for this, or recent updates where I have to allow the email to go to someone besides me?

function sendFormByEmail ()

{

  var email = "mye...@mydomain.com" //sets the recipient who should receive the email

  var subject = "TC Edit" //sets the subject of the email.

 

  var s = SpreadsheetApp.getActive().getSheetByName("Form Responses 1"); //get the spreadsheet by name

  var lr = s.getLastRow(); //gets the last row from the spreadsheet name from above

  var lrTime = s.getRange(lr,1).getValue(); //gets the value from the last range in the colum # specified for the 'Time' column

  var lrName = s.getRange(lr,2).getValue(); //gets the value from the last range in the colum # specified for the 'Name' column

  var lrCategory = s.getRange(lr,3).getValue(); //gets the value from the last range in the colum # specified for the 'Category' column

  var lrFixRequest = s.getRange(lr,4).getValue(); //gets the value from the last range in the colum # specified for the 'FixRequest' column

  var lrFixReason = s.getRange(lr,5).getValue(); //gets the value from the last range in the colum # specified for the 'Fix Reason' column

  var lrSchedulingReq = s.getRange(lr,6).getValue(); //gets the value from the last range in the colum # specified for the 'Scheduling Request' column

  var lrSchedulingReason = s.getRange(lr,7).getValue(); //gets the value from the last range in the colum # specified for the 'Scheduling Reason' column

 

  //this is the body of the message. Note: "+\n\n" adds a spacing between lines.

  var message = " Timestamp: " + lrTime +"\n\n" +" Name: " + lrName +"\n\n" + " Category: " + lrCategory+"\n\n" + " Fix Request: " + lrFixRequest+"\n\n" + " Fix Reason: " + lrFixReason+"\n\n" + " Scheduling Request: " + lrSchedulingReq+"\n\n" + " Scheduling Reason: " + lrSchedulingReason+"\n\n";

  MailApp.sendEmail(email, subject, message)

 

  }

[Keith Andersen]

Is this a Workspace account or Free Gmail account?

Check your quotas against how many emails would be sent with your script.

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

--
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 visit https://groups.google.com/d/msgid/google-apps-script-community/d7eb08fe-b6fc-40ae-97f0-620fd0e421can%40googlegroups.com.

[Peter Isakson]

This:

function checkQuota() { const remainingQuota = MailApp.getRemainingDailyQuota(); Logger.log("Remaining email quota: " + remainingQuota); }

Zero is bad.

[Kevin Corcoran]

About the quotas, as I mentioned if I I have the email to to ME it works, but to any other email address it stops.

Thanks

[Kevin Corcoran]

It's a workspace account I think, it's my profile on our business account

On Friday, May 1, 2026 at 10:55:49 AM UTC-7 Keith Andersen wrote:

[Kevin Corcoran]

Again, it can't be a daily quota thing. It works fine and will email my address, but will not email any other address.