Mail Merge Grouping Multiple row data- NEXTIF

CURLY BRACKETS MUST BE INSERTED WITH CTRL+F9
There's plenty of info on how to use VBA, or even using MERGESEQ and Directory to send multiple items/rows to a single recipient in a mail merge. By adding another column in excel, I was able to use the NEXTIF command and cycle through the items.
Please remember, CTRL+F9 to insert curly brackets in a mail merge--if you just type them in, they will not be recognized as code and your merge will fail.

CURLY BRACKETS MUST BE INSERTED WITH CTRL+F9
CURLY BRACKETS MUST BE INSERTED WITH CTRL+F9
CURLY BRACKETS MUST BE INSERTED WITH CTRL+F9
CURLY BRACKETS MUST BE INSERTED WITH CTRL+F9
CURLY BRACKETS MUST BE INSERTED WITH CTRL+F9
CURLY BRACKETS MUST BE INSERTED WITH CTRL+F9
Did I mention..
CURLY BRACKETS MUST BE INSERTED WITH CTRL+F9!!!

[TOMRYANLUKE]

To All - to edit the mail merge code (Alt+F9). I cant begin to tell you how grateful I am to you for this video. Again many thanks.

[lordmanor]

Oh my gosh, thank you SO MUCH for this! I had to do end of year donor letters where some donors were multiple-time donors. Each donation should be listed separately on the one letter and I was able to figure out how to do that from your video!

[charmainemacintosh]

I have been trying for three days to solve this. Such an elegant solution compared to the others I found including the Graham Mayor one to many add-in - which does work but is more complicated. Thank you, thank you, thank you!

[mariapittgoyanes]

Simply awesome! I had the time yesterday to apply what was taught in the video + all the useful comments and it worked perfectly!

[andrewclarke]

Thanks for this! It was super helpful. I will try to give back by adding replies to a few comments below that are asking about things I found out as I used this information to solve my own problems!

[angelakunz]

This is an elegant way to do this. My only issue was that I needed to put the bookmarks ID1 and ID2 in curly brackets using ctrl-F9 to get the system to do the comparison correctly. Once I did that it worked like a dream.

[karenbell]

This worked like a charm! Only suggestion I have - clarify that you repeat the nextif blocks for the maximum number of products/client. Maybe I'm dense, but it wasn't clear to me how many times I had to repeat these blocks, but I figured it out through trial and error.

[akodoori]

Hi... Can you upload the sample word document... I am facing difficulty trying to repeat what you have done... Thanks 👍

[timburen]

Dont know why but I had to change your code IF
other than that works brilliantly
thx

[MANILABORACAY]

Thank you 🙏 you save me tons of work and stress🎉❤😂

[elneamyo]

I'm using 365. Using the next record function and it's pulling all the data into a single merge document properly however the next recipient then goes to the second record. I know exactly how many records per merge I need (6) but instead of 3 emails with 3 groups of six records I'm getting 18 emails with each email being just one record down from the previous. Any idea how to get word to recognise groupings?

[sandeebar]

The answer to my prayers! Worked great. Thanks!

[lilianaortiz]

Very helpful! Just one question: if I want the data that I am trying to merge from excel to go into a table in a word template, where do I type the merge sequence?

[dean-johnston]

This is amazing. I have just 1 question, is there a way to remove the gaps after a search comes back with no results? I’ve got big gaps in my emails when they have just one number

[tinagilson]

Thank you for this video. I would like to add another merge field, such as product price after the product name. Is that possible with this coding?

[kellybelly]

This is so great, but I wish that you had shown us how to set this up in VBA! Some of us are newbies.

[Deb-tj]

Hi I tried this on an email merge I need to do for policies i have. I want the email to list all facilities for one policy showing they need to be renewed. .when i used your formula it was great if there was only one facility per policy, however, if there were more than one, the following would appear : Policy 236 Facilities 123, 456, 789 would appear which is great, but on the next email it would give Policy 236 Facilities 456, 789, Then on the next email it would show Policy 236 Facility 789 Then the next email would show the new policy number and it's facilities the same way any suggestions on how to fix it?

[leelaa]

did you ever upload the word document?

[whydonttheywrite]

This video is great, but one question, how would you change the code if you DO want the duplicate products to show?

[NickRigas-uouw]

This is great but not working likes yours is. I trying to send out letters similar to what you are doing with a little bit of variation. Can you assist?