How to: send emails to persons based on a checkboxed value list
I am trying to get this working:
In a file I have a table "A" with two fields:
There is a value list based on Table "A" "Name"
There is also a second table: "B"
- Here is a field "person" with a checkbox list based on the value list "Name"
- There is also a field: "mailto"
In this field I need (I think) the email addresses that match the checked records in the value list (separated with ", ")
how to do this?
In plain words: I want to mail persons based on a checkboxed value list. How to get the email adresses in a field or variable?