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.

 

[hfsitumo2001]

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.

That is why Trevor I want to modify the excel file by putting the period total in line with the name, how can I make macro to do that in my worksheet. Because there is like 800 people that I want to modify, because I want to compare their donation in 2023 to their donation in 2024.

Thank you,

Frank

 

[Gasman]

Methinks crossposted at https://www.utteraccess.com/topics/2066407?post=unread