Email templates and custom functions

Email templates and custom functions

Hello,

Email templates allow us to send email from the record owner, but don't allow us to use custom functions to create the content of the email.

Custom functions, allow me to build custom content, but don't allow me to send email from the record owner.

I'm stuck in the middle.

I wish to build emails with content tailored to the customer i.e. show an email with an html table of all quotes sent to the customer. Can anyone think of a good way to do this please?

Thanks in advance.