I have 2 tables. In one are my adresses and the other one I use to make a simple bookings. (Volunteer schippers on a small canalboat in Amsterdam ;-) They are related and that just works fine.
Now I would like to send all schippers from the adress-table an email with the booking to see if they are available.
First I just used the send mail function, but then it just finds the emailadresses I used in older booking-records, not all mailadresses from the adresstable.
Then I found this script:
Set Field [MainTable::Combine; List (RelatedTable::email)]
But now I just get one emailadress (the one related to the ID)
I want to get all mailadresses from the adress-table inserted in a field and then use this to send mails to all my schippers to see if they have time to steer the boat.
Thank you for helping.