Mail Merge multiple items to a single recipient in a mail merge

[@ehammond1]

Thanks for the help. Would be even more helpful if you included the code/example in the comments.

[@sitihasmah2818]

yes i agreed with you. it will be more helpfull to me.

[@WendySmith-r3q]

This was very helpful but I have an issue. In my example I am trying to send a letter to a Next of Kin with a list of people who donated to their deceased loved one. On page one I have the letter and on page two I have the listing of donors who gave to the deceased person. The first person in my excel data file works perfectly but the second person is missing the first donor in my excel data file. Is there something I am doing wrong my formula.

[@Markowia]

Same by me. It does not print the first line of the second person. A solution here will be highly appreciated and will beat this option: th-cam.com/video/MIfid43hlHw/w-d-xo.html

[@Cool92ice]

If I have a negative amount how can I show in word mail merge as bracket instead of - ?

[@monaalsayed787]

Thank you so much Emile, for the very helpful video. I was able to run runt he same merge on my data, but I found an error that I cant fix. would you be able to help me? The next IF is not working properly for the next record, it always skips the first row for each user in my sheet!!

[@cherrierose2887]

Did you ever find a solution?

[@lien355]

I tried it and it worked perfectly for Mail merge; but when I used mail merge tool kit ( to have CC option) it did not work any more; please help me

[@AnaghaKP-v6i]

Figures are not changing for me

[@RomaChib-v6s]

how to do mail merge multiple items to a single recipient and single attached in a mail merge