Generally, Word is better at documents than Excel, and Excel is better at calculations than Word.

Look into creating a UserForm (custom dialog box). This requires writing (not recording) macros.

• Create a Simple Userform by Graham Mayor, MVP
• Create & Employ a Userform by Greg Maxey

Your clauses could be stored in the template as AutoText. That is easier, at least for me, than putting the wording into the macro.

• Automated Boilerplate Using Microsoft Word
• Using VBA to Insent an AutoText Entry or other Building Block