Quote Originally Posted by macropod View Post
This would be a trivial undertaking using a label mailmerge - without ever needing to open the Excel workbook, let alone any VBA - using a two-column page layout with a 4-column table snaking from the top of one column to the bottom of the next and a suitably-sized column spacing in between.

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. Hence the desire to keep it in this form. It is a charitable organisation run entirely by volunteers hence the desire to keep things as automated as possible and avoid spending time producing each month. (The output list of members produced is issued each month and currently that is simply done by pushing a button in excel, opening results Word document and printing a hard copy; only issue is it is not in the best format for its then intended use.)

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.