EASE93
10-27-2021, 05:20 AM
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.
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.