Automatically fill word tables with excel data
Hi everybody,
I have multiple excel files which Always have the same format. Row 1 are the different categories (Adress, contact, name, etc) and under them are the data (Baker street 1, 0474 45 89 20, Patrick, ..), I included a picture to make this more clear. For each row of this excel file 2 new word pages should be made with on the first page some data from the row and on the second page some other data from the same row (see picture 2).
I first thought about making a big table over the 2 pages in the word file and then automatically let the data from excel extract to this word table for each row. But this turned out to be harder then it should be.
Any help is welcome and don't hesitate to ask questions.
Kind regards,
Lauren Van Roy
|