I have a word 2007 document with text in the left hand cells of a table.   It's a document containing children's school reports with teachers comments in so there is a repeating two page format but unique text inside the table.

A second word document contains text in the right hand cells of the table. (this has been pulled in from an external database). These will be levels which are not available until near the end of Summer Term.

I would like to combine them into a new document containing both sets of text.

I have been trying to use the combine facility but it will only let me accept or reject the changes, rather than keep both - although I'm sure when I first tried this it worked perfectly!

Alternatively, is there a way to merge the document with an excel spreadsheet, bearing in mind the spreadsheet would contain name, level 1, level 2, level 3, level 4 for each child and each leavl would need to be inserted into a different cell of the table in the word document.

I can't help feeling that there must be a way to do this in Office.  It would save SO MUCH stress and hassle for the teachers if we can work it out! 

• Edited by SharpyS Tuesday, March 24, 2015 5:07 PM

Yes it can be done via VBA (I think so), as Stefan suggests post it on the word developer forum.

Click on the 2nd link Stefan has suggested.

Maybe include this on the post, is there a way to do this via VBA (using macro) to automate pulling of data from word to