Hello, 

I was wondering if anyone can help me with a script that will allow me to compose an email, where the data is across 2 tables? 

I want to compose an email from a Quote layout I have built, which allows the user to email each supplier individually to place an order for items on a quote. 

I cannot use the built-in functionality because I need this action to be in the Quote table, yet the supplier's email address is in the Suppliers table....

Can anyone suggest anything? 

Thank you