Adam:
I don't think there is any automatic way of doing what you are wanting to do.
The macro function does not even work with that field.
You have to manually select the option of editing that field, and when the edit screen comes up, it says at the top you can right-click to activate macros, but you can't.
Your problem may be solvable, but it would require a major work-around and may involve third-party software.
I think we should add this to the list of tragic flaws with the letter writer.