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:
Quote:
|
On __________, the weekly job JTDA1001 ran and determined that there are __ unclaimed dingbats in the M35 inventory and __ blarticks. The next run will be on __________.
|
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.