Since SQL ban user from creating a variable of type text, is there any way to store more than 8000 characters in a local variable within
a stored procedure?

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).