...when an SMTP email script uses a field from another db...
db (database) is a somewhat fuzzy term in FileMaker land. Is this another file or just a different, related table in the same file? Does it make a difference?
True, it is a field from a completely different FM file and I have related it by a TO to the main table in this file.
Thank you for posting.
Since this error is specific to the SMTP Server, perhaps you can provide some more detail. In the Send Mail Panel, what SMTP Server is specified? Does the issue occur only on a specific SMTP server? What is it about the addressee that is being pulled with your script: the name? the e-mail Domain? Or are the address lines FullName and email address?
Additional information you can provide may help in narrowing down the possible causes.
SMTP server we are using is our Exchange 2010. We only have one server. The TO field is being filled in with a Field from Filemaker from a table in another file that I call PermGlobals (only one record and a field for each person's email). When I started doing this, whenever I get a 1506 error which suggests an email failture, the email still sends and my script captures the error and sends a duplicate of the Send email script step thus getting duplicate emails. I confirmed this by adding the number 2 in the second email script step.
Hopefully, these screen prints clarify.
Second screen print. This seems to be a known problem.
There is an extended discussion about the 1506 error including a number of tests and possibly resolutions. See if any of it helps.
In the following link, one person seems to have narrowed down the 1506 FM error but send email anyway issue:
I’ve been trying to crack the bug. Because in some cases it does work.
After some tryouts here I my findings using the SMTP Name field:
Link to text globalfield in the same file
Link to (global) calculation field in the same file (calc: link to globalfield in the same file)
Link to text globalfield in external file
Link to text field in the same file
Link to text field in external file
Link to calculation field to external file
Try and let me know. Hope to see this issue fixed soon.
Thank you for the screen shots. I apologize for the late response.
There is a possibility that the SMTP server queue is becoming backed up, generating the error. To test this out, try inserting a 1 or 2 second pause step in your script between each send -- removing the repeat send of the same message.
Please keep me posted with the results.