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

 

[Pat Hartman]

Mail merge = 1 record per document. So on top of getting the ID into every row of the speadsheet, you also need to get the data into a single row. I use OLE automation rather than mail merge so I can have subreports within one document. Baring that, an Access report will almost certainly be easier. Once you get someone to write the Excel macro for you.

On the other hand. You could turn on the macro recorder and drag the missing data down manually. Turn off the macro recorder. See what code gets generated.