Many to One Mail Merge in Microsoft Word

Posted on:  04/10/2017
Many to One Mail Merge in Microsoft Word

Microsoft Word performs a One to One mail merge by default. This means if you have five sales reps and each rep has 5 new potential leads, when you do a mail merge, each rep will receive five letters. That is 25 letters when ideally, you only want to send out five letters. Each rep getting one letter with their five 5 new leads on each letter.

Of my 250 videos on YouTube, two videos are dedicated to Many to One mail merge, which I refer to as Grouping Records. My two videos were created from Microsoft’s support article 294686. Microsoft calls a Many to One mail merge “Create a list sorted by a Category” in the support article. Regardless of what you call this type of mail merge, the Microsoft article isn’t easy to do and leaves a lot to be desired even if you get it right.

Videos on Mail merge with grouping

My first video shows the mail merge working. It is only 3 minutes long. The second video, which is 10 minutes long, I walk you through article 294686. It shows me setting up my data file, setting up the directory, explaining the key field, and typing the fields. As mentioned, Microsoft does an awful job with grouping records in a mail merge.

This is where Graham Mayor’s Many to One Add-In for Word comes in handy. I tested it on April 9, 2017, and it worked! Not only did it work, it is easy to understand, and you don’t have to type in a lot of fields. Before actually testing the Add-in, I read Graham’s Many to One page twice. I need to point out, I only tested it for letters in Word, The Add-in also covers email mail merge, which I didn’t test. I can definitely see companies needing this Add-in.

Mail Merge Graham Mayor

Video showing how to use Graham’s many to one merge add-in

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 16 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories