Quote Originally Posted by krackers View Post
But the data is held in an excel workbook, updated, added to and stored in that environment
. Excel is then used to sort the data required that then feeds into the word document
.
...
I am not an expert in Word and certainly do not use mailmerge. If you are saying I can easily transpose the data from current Word output to required output in a very simple way then I'd love to know more.
That is precisely what mailmerge is for - taking data from, for example, Excel and outputting it in Word.

See:
https://support.office.com/en-gb/art...f-932c49474705
https://support.microsoft.com/en-gb/...-to-print-form
https://support.office.com/en-us/art...B-0A948FA3D7D3