I'm trying to build an HTML body to be send via email to vendors.
The HTML body is dynamic depending on the number of vendor's invoices.

The HTML body along with the vendor's email address will be passed to a stored procedure (SP_SendSmtpMail) to send the message (The HTML body parameter in the stored procedure is defined as text).