May 20, 201015 yr I have a list of contacts that are created when I run a search on certain criteria. In list view I have contacts come with email addresses, some without. How do I create a loop script that will go through each record and if they have an email address copy it and put it into a field creating a list of the email addresses in that one field, for example the to field of an email layout. Thanks!
May 20, 201015 yr I don't think you need to do any of that. The FileMaker send email function has a checkbox "Collect addresses across found set".
May 20, 201015 yr Author right. but what if I still wanted to select the contacts that have email addresses and set a field to hold a list of all the email addresses separated by commas anyway? Thanks!
May 20, 201015 yr Set variable [ $emails; ""] go to record [first] Loop Set variable [ $emails; list( $emails; contact::email) ] go next exit after last End loop Set field [ someField; substitute( $emails; ¶; ", ") ]
Create an account or sign in to comment