Custom Host Macro in Service

I believe that you can do exactly what you are suggesting. The syntax is just about what you are using. The only hitch I’ve found is on hosts that don’t have this custom macro defined.

I recently did the exact same thing for an email alert solution.
http://forums.meulie.net/t/passing-paramater-to-email-script/6151