Automatically replacing placeholders in different word templates via Excel

[EASE93]

Hello there,
excellent forum!

• I have got an Excel workbook which contains two sheets
  
  • The first sheet contains data from Customer Base Mexico
  • The second sheet contains data from Customer Base Canada
  • I have got one template (word file) for Canadian customers and another template (word file) for Mexican customers
  • What I would like to achieve is that double clicking into the respective row in the Customer Base List will lead to a word file
    
    • that is based on the template for the respective Customer Base (e.g. Template Canada for Customer Base Canada)
    • and in which the placeholders (e.g. <<Name>> ) are replaced with the real values from the customer list (e.g. "Anita" instead of <<Name>>)
  
  
• So the macro should be able to create and save a new word file based on the respective template and replace the <<placeholders>> for the real data from Excel

Would be very much appreciated if someone could help here. I have attached a "dummy" excel file and "dummy" templates.