Convert a lot of HTML to email in VBA or alternative solution?

[NikToo]

I've been asked to do a macro which sends out an email to a list of recipients. So far, no problem. Then marketing gets involved and sends me a humungous amount of HTML for the email they want. Divs, spans, tables, the works, over 600 lines of code.

So, apart from a nightmare of having to convert this VBA, what could I do? Anyone have any clever ideas? Can I call the code from elsewhere and pass it a variable (recipient name)? Outlook template?

 

[NikToo]

Got it sorted. Made an OFT Template from HTML. Which presents its own issues...