Hi,
I created a calculation tool in Excel where you only have to enter a personal ID number and it loads all employee information in the excel file and calculates specific parameters. Now, I have Word letter templates in which I would like to automatically fill the information from the Excel file. I don't think a serial letter would be appropriate because this will be always just for one employee. So I calculate something for an employee at the end of the month and afterwards I would like to have the letter. How do I get the information from the Excel file into the letter in word? I will attach an excel file to demonstrate what I would like to achieve.
From this Excel I would like to transfer some of the numbers to a word template. What would you recommend to do here?
Thanks a lot for your help
Regards

Attached Files

example excel.xlsx (13.2 KB, 11 views)