I’ve done HTML emails with VizAlerts as have other users…what exactly is the challenge you are having?
I need color for percentages as positive to be green & negative to be red
also pulling top 10 products with other measures.
I am using VizAlerts Body* to send measure as sting
Note: As Measures are computed using tableau.
Hi, I'm no great shakes at HTML...in this case you'll set up the Body calculation something like this:
"<p> some text here </p>"
+ IF [measure] > 0 THEN
'<p><span style="color:green">' + STR([measure]) + '</span></p>'
'<p><span style="color:red">' + STR([measure]) + '</span></p>'
Note that Tableau's string formatting of numbers is minimal so you'll need to also add units, handle displaying the right number of decimals, etc. There are other posts on the forums around this.
PS: You might have done this already, please question whether you really want to go down the route of writing complex HTML when the same view could be built in a few mouse clicks in Tableau and a PDF or PNG sent instead.
PPS: Please carefully consider whether you really want to use red & green possible, this post by Jeffrey Shaffer has a good overview of the issues w/using red & green: 5 tips on designing colorblind-friendly visualizations | Tableau Software