View Single Post
 
Old 03-22-2016, 06:36 AM
hannes.ledegen hannes.ledegen is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2016
Posts: 5
hannes.ledegen is on a distinguished road
Default 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!
Reply With Quote