I haven't got it working but I did get the isolation of the issue which is that the copy from the table to the HTMBody is not working out. So I know that I need to to find a different way. I don't know about placeholders and Replace() functions and I will investigate that. If you have any example links, that would be great but otherwise Google is my friend. I am a believer that I learn a lot more by searching to resolve issues so I really only post here if I think it should be working and isn't or I really cannot find out how to take the next step. As it often turns out I just don't know how to frame the question properly - the answer is out there, I am just not asking correctly.
vblEmailID is used to locate the correct record - it is the autonumber. I just hard code it - in this instance vblEMailId is 6 which is the right record in the table for this email.