Link to home
Start Free TrialLog in
Avatar of rvfowler2
rvfowler2Flag for United States of America

asked on

Filemaker Script Sends Emails with Repeating Recipient Name

When this script is executed, it sends an email to several employees. In Outlook, only one email is received by each person (as it should be), but the TO: header contains many repetitions of the recipient's email address. I can't figure out why this happens. There is a loop in the script, but the email step is called OUTSIDE the loop. I have attached a screen print of the script, with certain details omitted for privacy.

We are sending via SMTP, on MS Exchange


emailScript.jpg
ASKER CERTIFIED SOLUTION
Avatar of webwyzsystems
webwyzsystems

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Member_2_908359
Member_2_908359
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rvfowler2

ASKER

Thanks, will look into this.  Just to clarify, we don't get a bunch of emails, just that it is addressed numerous times.  The Exchange Server probably has an automatic function to only send once when addressed multiple times to the same person.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great tips, but they don't address our problem.  We execute the code, e.g., "Set Jims Email Body" more than once because we want to append to the body text field, but no we have not coded a TO section in the script Jims Email Body.

Also, the script is designed to only send the whole foundset once.
We figured it out.  Though we did check the radio button "One email using data from the current record," we did not uncheck the check box "Collect addresses across found set."  Once we unchecked it, this fixed our problem of mulitiple addressees.  However, one last question.  Why is this one by default and why is it not dependent on the radio button above it?  Thank you.
Actually, in rereading this, it seems that lesouef was probably refering to unchecking the checkbox after all.  Anyway, it worked.