thanks Paul, after looking at this i just cant get it work. i have transfered all into one spreadsheet using a VLOOKup but my main problem is now i have a table of data which needs to be repeated based on a key field number.
i have attached a screenshot of the word file with the merge fields where they should be placed and a PDF of how the finished item should look. I have also shown the Excel records so to the right of this it has everyone details 13 times in the record
after searching google/youtube i think an SQL code may solve this but is totally beyond me
thanks for your help
|