to send an emails with below points

[tghadage124]

Hi all , 

I have a requirement where I need to send email with below format :  

 

this is sample format , the company fields are above are from different table and quantity fields are from different table but field that are shown in the image will be from two different tables .

can you please guide me on how to do this ?

thanks

[Tai Vu]

Hi @tghadage124 

Notification Email Scripts [sys_script_email] would be what you are looking for. 

You can query and retrieve the data you want to display in the notification, and customize the email body layout to meet your specific requirements, e.g: table with calculated amount.

Cheers,

Tai Vu