So let's start here: Tell me about the way the data must look in the email. Is it possible to just paste it in there, once you have it in the right form? What I mean is this: Suppose we write a macro to assemble all the data from Excel and set it up in a single location; can you just cut and paste it from there? Or does it have to be in some particular format in the email, like in rows and columns or something?

That wouldn't be the final form of the macro, you understand. I'm thinking about writing the macro to pull the data from Excel, thus saving you some of the work. Once that's working correctly, a next step would be to enhance the program to set up the email. But we don't have to do it all at once; we can do it a piece at a time and get benefits from it as we progress.