AnsweredAssumed Answered

get all data field from all records from related table to send mail

Question asked by franknamal on Oct 16, 2016
Latest reply on Oct 16, 2016 by philmodjunk

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.

Frank

Outcomes