Creating a list in a field.

[etsmarines]

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!

[bruceR]

I don't think you need to do any of that. The FileMaker send email function has a checkbox "Collect addresses across found set".

[etsmarines]

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!

[bruceR]

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; ¶; ", ") ]