Excel to Word Mail Merge

[BrownShoes]

I have an Excel report output from our MIS which shows incidences recorded for staff.

Column 1 shows the name of the staff member with column 2 showing each incident recorded.

At the moment my mail merge will produce a separate letter for each incident...meaning that I have multiple letters for some...I'd prefer to be able to merge several rows into one doc if possible ( i.e. name appears once with pertinent column 2 incident entries).

Simplest solution possible appreciated.

[Seb1780]

Graham Mayor is my main source for all things Word

 

Merge Many To One

[BrownShoes]

Thanks...will check this out later(on my own time!).