Is it possible to have the info populated into a template fro outlook or will the html have to be written into the code of the macro?

I've been assuming that the email would have a lot of text that is the same all the time, and our macro will plug a few values in here and there. Like this:The macro's responsibility will to pull the data from Excel, pull up a copy of the above template and find the blank places to plug the data into.

That would probably involve no HTML tags in the macro—or at most, maybe you'd want to insert a tag or two around special data, say <b> and </b> around any value greater than the norm. We can decide as we go along, I should think. But mostly the HTML would already be in the template and we're just stuffing our values in among it.