Use MS Forms to populate a Word document from a template, then email the document (either in PDF or .docx format) to an email recipient

[DavidSpro]

We need to streamline Dynamic Risk Assessment our consultants undertake onsite.

I have created the Forms (although I need to add a few more fields).

When submitted, I want the submitted Forms data to populate a Word document (that contains tables, graphics etc) from a template, then have it emailed to our admin team.  We dont need to save the Word document generated by the process.

Our current word form looks like this:

The form pretty much replicates the above, although the answers to the form will replace the Yes/No/NA column.

Where will the Word template need to reside and how can I import the Form Data? Clearly, its cant be on a local drive.