More info please. Where are you getting the found set of names? From which layout, TO?
What TO is the layout where you send the emails based on, and what is the relationships?
List lists data from related records.
The "list of" summary field lists data from the current found set.
ExecuteSQL can list data from any table in your file, related or not, filter it, sort it, concatenate data from several fields into one....
Can I use Execute sql to take a list of names and automatically put the
list in the body of an email?
All three methods that I mentioned:
List, the "list of" summary field, and ExecuteSQL can be used to do what you ask.
Which is the best option depends on the design of your database and, for the last option, your skill in putting together a SQL query.
Please note that I do not know the design of your database.
List, the "list of" summary field---worked perfectly......tried execute
must have syntax trouble--always the question mark.....anyway
thanks for the help---you are always great
I think the simplest way to do (i.e. transfer the list data to the body of an email) is to capture the result of your listing calculation (whichever of the methods you choose to assemble the data) as a variable, and then just place the variable in the email body. This is simpler, in my view, than putting the calc inside the email setup step.
For 'standard email messages' and form letters, I put the basic text into a field and use the substitute function in a script to combine that text with FileMaker Data. This allows me to put up the basic message in a searchable table where authorized users can make edits and adjustments to the messages without them having to contact me to make minor rewrites to the messages.