Sending a concentrated email of all the order details from the subform

Sending a concentrated email of all the order details from the subform

טקסט מקור

I am building an application that sends orders of goods to the email of several suppliers simultaneously. For instance- in a restaurant that has a supplier of drinks and a supplier of meat and a supplier of vegetables, the restaurant owner will create a new order and order through the subform all the products he needs from all the suppliers. The problem is that I am trying to build a script that will send a centralized email to the supplier with all the products that the restaurant owner ordered, what happens is that a separate email is sent to each product. Adds a picture of the script: