![]() ![]() ![]() Later on I want to be able to automatically save it to pdf as well with the same button but first I want this to work. It will then check where the ID is placed(which row in A column) in the excel sheet which is A3 for this example and will pull the rest of this person's information into the word template I have created beforehand.(ID, Name, Last Name, Country and Date). When a user runs the code it will pop up an input box and it will ask him to type an ID, I want to have a button which will ask for an ID input and will then take all the other info of that person and place it in the word template in the correct place. I have data like this in my excel sheet : I am trying to create a code which will be executed with a click of a button in the excel sheet and will ask me for an input of a cell value in excel which will then take all the data from that cell's row and insert it accordingly in the word template where the mail merge tags are.
0 Comments
Leave a Reply. |