Mail merging words with data from excel

[hfsitumo2001]

Hello,

In case of the source of data is like in the attached for Mr. Y, the data for him is not only in his row, but below the row too. How can we make mail merge. If like Mr X is easy just pick up the columns in his row.

Anyone can help me?

Thank you

Frank

 

[Trevor G]

For your mail merge to work each row from your workbook will need the Donor Name otherwise the mail merge won't be able to identify the donor.

It would also be helpful if you could let us know how the word document is laid out and where the fields would appear.

 

[Gasman]

Would be eaiser to just use a report with the same layout as your word document.