Is this with Mac OR PC?
I assume you go with
Send Email [via SMTP]
If though and if mailing like this will always be sent by your own computer, changing SMTP-Setup to another NOT Google mail server from your private accounts would be worth a try.
Be aware that most of the internet provider have a max. Limit of mails to be sent per day to prevent spamming.
250 mails at once could already exceed this limit. I was facing such issues and started some research.
Even with the Mac iCloud Server is a limit probably lower than your 250.
Sending a 100 today, a 100 tomorrow, and so on, could also be a option.
Google set' restrictions regarding security recently so I was running into issues with "SSL-Errors" as well …
Thank you for the reply. This is on a Mac (iMac). At this point we do not have another SMTP server to use and Gmail is what we use for email. I spent a bit on the phone with Google trying to troubleshoot and they said the limit was 2000 per day, per user. We checked and the messages are going out one at a time, nothing is being flagged. Google reported they aren't seeing any evidence of messages being blocked or even reaching their SMTP server.
They may be off-putting the fault, but he said from everything he can see, the emails being blocked was not due to Google. So I'm lost at this point.
Looks like we have to start some try&error sessions
Since you don't get any error message, I would assume that it's not related to this issue:
Do you send 1 Email with 250 addresses OR is this a Loop where 250 emails get sent one-by-one?
If this is built on a loop to send one-by-one, you can try with a Pause Script [0.2 seconds] before 'go to next record' step.
You could also use Apple Mail with the Script option
Send Mail [ Send via E-mail Client ; With dialog: Off]
The problem with this tests is those parents receiving numerous test emails
That thread does not seem to apply here. I believe the script sends each email individually (just a running list of 200+ parent details). I have a meeting with the guys from Proof - who manage our database and I will mention this. The Administrators who use this made note that after they get blocked, if they wait 5 minutes they can do another batch. It may be that a brief pause between each email might be the key.
Thought from left-field: Any chance the router is getting overwhelmed, and shutting down the port or switch port temporarily so it can sort out what's happening. Kind of like a flood prevention.... Now that I think about it... I remember learning about that feature with routers where the switch port will "turn off" if traffic is beyond a certain range (God I forgot everything I learned from the CCNA)
The Administrators who use this made note that after they get blocked, if they wait 5 minutes they can do another batch. It may be that a brief pause between each email might be the key.
That's a important fact which can help to narrow this down. Even to learn to know after how many emails the routine aborts can be helpful.
When FM Scripts won't work, - 'specially with Loops and formulas, script tasks as 'commit', 'refresh' and/or Pause [… seconds] can fix it.
Thought from left-field: Any chance the router is getting overwhelmed, and shutting down the port or switch port temporarily so it can sort out what's happening. Kind of like a flood prevention....
Unlikely unless any dedicated configuration has been set up with your router.
Now that I think about it... I remember learning about that feature with routers where the switch port will "turn off" if traffic is beyond a certain range (God I forgot everything I learned from the CCNA)
That brings us to another possible work around: Try to send 1 Email with 250 addresses.
So we consulted with Proof, our management company and they are thinking it's the gmail smtp that is restricting the outgoing mail. We will have to look into alternative servers, possible a relay server to try and solve this issue. I can't say there is a direct fix that we know of, but i'm sure it's due to the database design, and a relay would be the solution.
I use gmail and I tend to "batch" my sends with pauses between the batches. Another tip is to place different subject (append 'batch number', for example) on the emails and a few other tricks to make the email less prone to be labeled "spam" (whether gmail or other mail services).
We are coming across this increasingly. It is NOT a FileMaker issue. We have a specialist FileMaker product that handles bulk mail and we have found that there is a major problem with people completely misunderstanding the implications of the "Can spam act". For a comparison takes about 20 seconds to send a full HTML email to 1000 recipients through our product using a bulk mail provider.
SMTP providers will restrict email volumes, both the number of sends and the overall volume to help reduce the amount of Spam. If they don't do this they get sued and fined by governments.
The only way to successfully send the quantity you are trying to and ensure that you have a spam free record on your email (equally important) is to use a proper bulk mail provider and send all bulk mail through them
Happy to help further but for certain you can't do what you are trying to do with gMail or any other normal mail sender.
I deal mainly with small non-profit organizations, so my approach to this may not work for you. When they do mass e-mailings, it's typically to members (or parents of members) of the organization, alumni, donors, and the like. I advise them to send out no more than 100 e-mails at a time, to avoid triggering the anti-spam blocks that might exist at various points downstream in the e-mail path. I provide them with an "Initial" field, calculated as the leftmost character of the "Family Name" field, and advise them to do Find operations for, say, "A..C", "D..G", "H..L", etc. until they've worked their way thru the alphabet. It's tedious, but the amount of time they have to spend doing each Find provides a kind of built-in "rest period" to allow the previous batch of e-mails to be well and truly cleared out of the "send" queue.
Yeah, it's kind of kludgy, but these are non-profit organizations that are chronically strapped for cash, so they're used to making do.
Unfortunately this approach has got some non profits into real hot water as the system is getting tighter. I have had to advise a few in the last months that finished up with virtually no email at all because of it.
Things are getting tougher and tougher as the "can Spam Act" truly intended.