How can I input text that varies into an email macro?

Correct. That can't work.

I'll see if I can find the thread that explains why, and post it here.