I have a pre-built Word form document that I use that has multiple fields that I fill out (customer name, dates, etc.). I usually copy/paste information to this document from other sources (Excel, Word docs, etc.).
QUESTION: I need to create a way to automate moving the required data from cells in an Excel spreadsheet to the specific fields in my Word form document fields. I need vba to search for a particular field from excel and search it in the word and replace it with the response.
For example: I have a customer name field in excel where I put Customer Name = Sid. and I have template in Word where in multiple places I have to write customer name. so what vba should do is it should search customer name keyword in Word template and replace it with my response which is Sid.
QUESTION: I need to create a way to automate moving the required data from cells in an Excel spreadsheet to the specific fields in my Word form document fields. I need vba to search for a particular field from excel and search it in the word and replace it with the response.
For example: I have a customer name field in excel where I put Customer Name = Sid. and I have template in Word where in multiple places I have to write customer name. so what vba should do is it should search customer name keyword in Word template and replace it with my response which is Sid.