Different Word Template based on cell value

[scotsrule08]

Good evening,

I am needing some VBA to select the correct word merge template based on a cell value. I receive a spreadsheet with all of the data to perform a word merge. Not every row will be the same template. I need the template used to be determined by the value in column "A"

For example If the cell says "Invoice" use the template named c:\desktop\invoice2019.doc
if the cell says "RMA" use the template c:\desktop\RMAform.doc

etc. Then perform the word merge.

[FONT=&quot]Template[/FONT]	[FONT=&quot]Price[/FONT]	[FONT=&quot]Item[/FONT]
[FONT=&quot]Invoice[/FONT]	[FONT=&quot]2[/FONT]​	[FONT=&quot]BANANA[/FONT]
[FONT=&quot]RMA[/FONT]	[FONT=&quot]342[/FONT]​	[FONT=&quot]POTATO[/FONT]
[FONT=&quot]Congratulations[/FONT]	[FONT=&quot]32[/FONT]​	[FONT=&quot]CUCUMBER[/FONT]
[FONT=&quot]RMA[/FONT]	[FONT=&quot]4[/FONT]​	[FONT=&quot]SALAD[/FONT]
[FONT=&quot]Congratulations[/FONT]	[FONT=&quot]234[/FONT]​	[FONT=&quot]APPLE[/FONT]
[FONT=&quot]Invoice[/FONT]	[FONT=&quot]32[/FONT]​	[FONT=&quot] STAR FRUIT[/FONT]
[FONT=&quot]RMA[/FONT]	[FONT=&quot]28[/FONT]​	[FONT=&quot]CRUTON[/FONT]

<tbody>
</tbody>

Thank you for any assistance!