Batch create word files with link to changing excel
Hi,
I need to create a batch of word files which contain links to an excel file.
I have an excel file containing names and areas. I need to create a lot of word files, each file containing the name and areas of one row in excel.
e.g.
Word:
This person [NAME] has acces to [area(s)] in the year 2016.
Excel:
|NAME| AREA | AREA | AREA | AREA | AREA |
|Eric| Area 1| Area 2|
|Joseph| Area 3|
|Hannes| Area 1| Area 4| Area 7| Area 3| Area4|
The output should then be 3 word files in each of which [Name] is replaced by the name in cell A1:C1 and [area(s)] by the areas in cells B1:C5. Each word file having the content of a seperate row of the excel file.
file 1:
This person Eric has acces to Area1 and Area2 in the year 2016.
file 2:
This person Joseph has acces to Area3 in the year 2016.
file 3:
This person Hannes has acces to Area1, Area4, Area7, Area3 and Area4 in the year 2016.
Is this possible? And if yes, do you always see the [NAME] and [Areas] as if you inserted a cell or can you get just the tekst there?
Thanks in advance guys!
|