I'm trying to create a macro in an excel workbook and have a button so that
when a customer completes the form, they hit the macro button and it creates
an EMail and populates the subject line. The folks who use the form download
it from my company's internal portal; all users are internal to the company.

Note, I have a rule set up in Outlook so that these EMails automatically
route to another folder so they don't get "lost" in my general inbox. Users
send the excel attachment to me OK, but the subject line is usually missed,
even though I have mistake-proofed it as best I can.