I am trying to create a mailing list with emails from different contacts. I have a table where every record is a mailing list. It has a portal with the contacts I want for each specific mailing list.

I need a script that merges all the emails from every portal row separated by coma, and pastes that on another field to be used for sending the emails.

I assumed that a script would be the best solution, unless there is another easier way.

If you had FM8 you could use GetNth Record and use a calc/custom function to automatically do this for ya. With V7, basically, you'd have a global field that is your to: field. Then loop through your records like so:

Set Field "to" ; emailaddress

loop

Set Field "to" ; to & "," & emailaddress

go to record next [exit after last]

end loop

You don't need a custom function or Get Nth function a Value List does the trick. See attached example.

Mailing_List.zip

Thank you for your replies, I tried the script solution and it works, but the calculation with the value list is just fantastic, I appreciate your time answering.