Export data from excel in word

[claudiualx95]

Hello guys! I want to export specific cells from excel document to fill a word document.
To be clear. I want to generate many word documents by having the template. For example I have the word document with a list of tasks and an excel document with personal data of people who have to fulfill the tasks. I want to take the personal data from excel and complete the word document with it, in a specific range. I want to make it look something like it:

Excel data:

Name Surname Working place Project:
AAAA AAAAAA XXXXXXXXXX YYYYYY
BBBB BBBBBBB ZZZZZZZZZZ GGGGG
CCCC CCCCCC TTTTTTTTTTT UUUUU



Word document content:

NAME
SURNAME
WORKPLACE
........
PROJECT
......

Where there are dots is the content of the word document. I want to take the information from the excel document and fill where there is the Name, Surname etc.

Do you know any solution? Thank You!

 

[jmacleary]

Hello and welcome to the forum. You will need to use the Mail Merge functionality of Word. There are loads of examples and tutorials on this, just google something like 'word mail merge from excel'.

 

[claudiualx95]

Thank you very much! It was really helpful!

 

[jmacleary]

You're welcome and thanks for the feedback.