I'm using Filemaker Advanced v14 and want to send an email to each of the records in my small database with the variable salutation "Dear Firstname" in the first line of the "message" field in Send Mail. The emails send perfectly without that variable salutation.
I've added the variable in as "Dear " & Firstname &
and it works but only puts the first name of the first record in all the emails.
So I'm clearly doing something wrong.
I fear I need to set up a loop within the script to (not sure how) make sure it puts the correct first name into each email?