Sendmail based on individual subform rows on form submission

Sendmail based on individual subform rows on form submission

Salut,

My order form has an product subform with items that can be bought from different suppliers. I would like every suppliers to receive an email saying "you have an order" with all items (records) of the order associated with them. The suppliers' emails are pasted in the individual rows.

Is that possible ?

Note that eventually, I will transfer the data to Books, to create a work order per supplier. If it is much trouble making independent sendmail with Creator, and easy to do it with Books, I might just wait to do it with Books.

Sylvain