Ms Forms to mail merge to email (power automate?)

I’m trying to covert an old excel to word mail merge (bulk) process monthly…to an on demand type process.

Example: clerk maintains excel table, then about~100 rows/ month, she mail merges to the template, and then prints and sends letters out.

I’d like to cut the job out using automate:

User clicks link and puts data into MS Forms,
Output Data sent to sharepoint
Upon new sharepoint record being submitted ,
Automate grabs data, merges with template, and saves the letter (word)
Then automate creates an email and sends the letter to the form filler.


Don’t ask why, the form fillers are internal and they must “wet” sign the letters, so no pdf or merge data into an email.

I just basically want to make an on demand letter generator where I can control the base template and staff can have a the letter updated using Forms.

Doable?