Many to One Mail Merge in Word using Graham Mayor's Add-in by Chris Menard

  Рет қаралды 67,850

Chris Menard

7 жыл бұрын

Note: I did not create the Add-in tested in this video. I merely tested it to see if it was easy to use and if it worked. It does.
I tested Graham Mayor's Add in today. It works. Microsoft Word's mail merge is designed to do one to one. So if you have three doctors with ten patients each and you wanted to print letters for the doctors, 30 letters would be printed. What Graham's add-in does is allow one letter for each doctor with all the patients for that doctor to show. Only three letters instead of thirty letters.
Link to Graham Mayor's webpage: www.gmayor.com/ManyToOne.htm
Chris Menard provides Microsoft Office training in Atlanta, Gwinnett, and other cities in metro Atlanta.
chrismenardtraining.com
chrismenardtraining.teachable.com/p/excel-tables
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZfaq keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

Пікірлер: 55
@whydonttheywrite
@whydonttheywrite 5 жыл бұрын
Thank you so much! I was reading over the instructions for the Add-in and just getting more overwhelmed until watching this video and it worked perfectly for my purposes.
@ChrisMenardTraining
@ChrisMenardTraining 5 жыл бұрын
Glad it worked. I felt the same way initially, so I figured other people were stuck.
@clewerhillroad
@clewerhillroad Жыл бұрын
Holy cow ...quite possibly the most important video I've watched on youtube ....just saved my hours (...and hours of work!) Thanks
@ChrisMenardTraining
@ChrisMenardTraining Жыл бұрын
Thanks, David. I'm not sure about the most important video, but it made my day.
@clewerhillroad
@clewerhillroad Жыл бұрын
@@ChrisMenardTraining Chris that just might be a function of what i watch on KZfaq :) Many thanks again.
@tylercerny5013
@tylercerny5013 4 жыл бұрын
Works great! Does anyone know how to select only a few records from the list though? I only select the few I want in "edit list" and no matter what it generates letters for the whole list.
@180matrixgmail
@180matrixgmail 2 жыл бұрын
it took several times to get the results out but it saved me hours of effort and changes. Thanks!
@ChrisMenardTraining
@ChrisMenardTraining 2 жыл бұрын
Glad it helped! I appreciate you letting me know. This isn't my add-in, and it worked for me years ago. Glad to know it is still working,.
@akodoori123
@akodoori123 2 жыл бұрын
Which version of word are you using
@gumnam9421
@gumnam9421 6 жыл бұрын
Hy if i have a one person data more then one cloumn so then how i can use mail merge option...
@grahammayor3192
@grahammayor3192 3 жыл бұрын
Please note that the zip file no longer includes the self extracting exe file. Consult the Readme file in the zip for installation instructions. There have also been significant enhancements to the add-in since the version illustrated above, but the principles of use remain the same.
@reneedunn2387
@reneedunn2387 2 жыл бұрын
I wasn't sure I understand how to install with the new instructions.
@32982200
@32982200 3 жыл бұрын
Hi, thanks for the video. It worked flawlessly for me when my output was a word file. However, when i tried making the PDFs keeping all the parameters same, I'm facing an issue. In the PDFs generated, the Merge Field headers are being shown like instead of taking the name from the excel. Please help!
@tobyteng7522
@tobyteng7522 3 жыл бұрын
Thank you. Your instructional video is super helpful.
@ChrisMenardTraining
@ChrisMenardTraining 3 жыл бұрын
You're welcome!
@JTZ1985
@JTZ1985 7 жыл бұрын
Hi, It is really perfect solution but i have trouble with using "|" (pipe) character. I have string like "KK|000000|0008483844" and i need to have it in one cell of table but it is always displayed in next line (part of text after pipe character). Could you please help me wit this issue? Thanx
@mindystein4756
@mindystein4756 3 жыл бұрын
I love this however I have a problem. I'm merging to email and the 2nd row of data is missing some on my data fields, specifically the fields with $ and %. It pulls in correctly to the first row of each merge?
@davidd2136
@davidd2136 6 ай бұрын
Thank you so much!
@jonrusso7213
@jonrusso7213 4 жыл бұрын
I just downloaded this and tried installing it. I keep getting a "Word cannot open this document template C:\...Ver 14.7-64...) any ideas?
@nvsh241
@nvsh241 2 жыл бұрын
Thank you for this tool. Currently m constantly getting am error I.e. " Runtime error 6, overflow". Earliest I was able to use this function however now due to above mentioned error I'm unable to use it. Hence it would be grateful if you can assist . Thank you
@umysashah4896
@umysashah4896 5 жыл бұрын
i am getting an error message "object variable or with block variable not set". plz help
@harishpatil3528
@harishpatil3528 3 жыл бұрын
Sir please suggest mail merge many to one
@ahawk850
@ahawk850 5 жыл бұрын
I spent all day trying to figure out how to do mail merge with grouping in a table. I hope that program will work with MS Access tables in a mail merge. Thanks for the video
@michellecliff8689
@michellecliff8689 3 жыл бұрын
No it does not
@akodoori123
@akodoori123 2 жыл бұрын
Does it work with word 2019??? I am having trouble to get it to work
@RaulAndresdelCantoZahr
@RaulAndresdelCantoZahr 2 жыл бұрын
Gonna try it
@terihedrick1460
@terihedrick1460 7 жыл бұрын
Can this be used with the Microsoft Office Online Version or do you need to have it loaded on your computer?
@ChrisMenardTraining
@ChrisMenardTraining 7 жыл бұрын
Teri Hedrick Good morning. You must have the desktop version of Word.
@yongwenshao1061
@yongwenshao1061 6 жыл бұрын
Hey Chris, Appreciate the video, I am able to show multiple sub items, however, having trouble getting the grand total work out correctly?Do you know what might have gone wrong?
@ChrisMenardTraining
@ChrisMenardTraining 6 жыл бұрын
Are the totals with the dummy (sample) data wrong?
@yongwenshao1061
@yongwenshao1061 6 жыл бұрын
No is not, i'm trying it on my own template, don't know how he did it in his?
@saikumarmanchala4068
@saikumarmanchala4068 2 жыл бұрын
I'm getting VBA error 1004, I moved the file to trusted locations still facing the issue. Please help
@loriclark3247
@loriclark3247 5 жыл бұрын
this worked for me when I had donation letters and listed each donation that a donor made during the year on one letter . The only problem I had was formatting the amount as a dollar amount. The first one contained the $ sign but any other amounts listed on the same letter did not. When I changed the field coding then I no longer got the whole list of numbers, only the first one showed up. thank you for the video explanation ! it would have been really hard to read through the website and figure it out.
@ChrisMenardTraining
@ChrisMenardTraining 5 жыл бұрын
Thank you. I agree with your comment. The website info was hard to figure out.
@mindystein4756
@mindystein4756 3 жыл бұрын
@@ChrisMenardTraining where is this questions Video explanation? I think I'm having this same issue, I've watched the tutorial video several times
@tokofahmi2789
@tokofahmi2789 Жыл бұрын
How to add CARDTEXT of SUM ABOVE? Btw thanks for the video, it was helpfull
@ChrisMenardTraining
@ChrisMenardTraining Жыл бұрын
Thank you.
@priya.r5756
@priya.r5756 3 жыл бұрын
While downloading the file from gmayor website, no exe file is there. Any solution ?
@grahammayor3192
@grahammayor3192 3 жыл бұрын
Read the readme file in the zip!
@thecritico
@thecritico Жыл бұрын
Has anyone figured out merging to email messages? No matter what I tried it merges but doesnt combine many to one. Only works for individual word files. Those are the two I tried.
@elainedawson2145
@elainedawson2145 Жыл бұрын
I have been using the process for many-to-one merge to email for several years. We use it to send incomplete grade reminders to students and to faculty, sending a list of all their incomplete grades in a single email. The only piece of the macro that doesn't work for me is the part where you tell Outlook to send all the emails. I have to send them individually. Still a HUGE time saver and our students and faculty really appreciate only getting ONE email instead of several or more.
@thecritico
@thecritico Жыл бұрын
@@elainedawson2145 Hi, I actually figured everything out and now using it the way I wanted. Sending a single to multiple users with all info related to that user. Let me know what you are dealing with maybe I can help figure it out.
@MuhammadArshad-ck8sr
@MuhammadArshad-ck8sr 6 жыл бұрын
pl give me download working link. the link iven is not have .exe
@ChrisMenardTraining
@ChrisMenardTraining 6 жыл бұрын
Muhammad, go to Graham's website here. Click Word Pages which is across the horizontal menu. Scroll down and look for Mail merge - 'Many-to-One. Click it. All the way at the bottom is the Add-In he wrote. As you can see there are a lot of instructions.
@jawalim1996
@jawalim1996 3 жыл бұрын
Its a false positive detection.. its not a virus. the website explains why cause the add in accesses the registry. You have to trust the guy, he is a famous Microsoft MVP, and a generous one with genius solutions, or else find yourself another solution.
@grahammayor3192
@grahammayor3192 3 жыл бұрын
Thanks for the vote of confidence. :)
@cathyransom9670
@cathyransom9670 3 жыл бұрын
Has anyone tried this with email? I am trying to merge a Many to one in emails instead of word doc. Also - video is super helpful; I just need to know if this works as I have a file of 5K lines that need to be sent to project managers. Thanks ;)
@grahammayor3192
@grahammayor3192 3 жыл бұрын
It works fine with email provided your default e-mail application is Outlook and it is selected in the configuration.
@daveloose9888
@daveloose9888 3 жыл бұрын
It probably wasn't a good idea to advertise this product developed in the UK. I ended up hating it, and it took me several hours with microsoft tech support trying to locate the add-in file to uninstall it. Terrible experience!
@worldonfire9998
@worldonfire9998 Жыл бұрын
Wow seriously? Well some people are just too simple to work with
@luisdiaz6092
@luisdiaz6092 6 жыл бұрын
Hi. Please share this file without virus. It's very useful
@ChrisMenardTraining
@ChrisMenardTraining 6 жыл бұрын
Luis, I just demonstrated how the Many to One works. I didn't create the add-in. I was just testing it to see if it worked. I'll post a comment on his website telling him it has a virus. Thanks for the update. I'm sure he doesn't know that.
@lyndam1917
@lyndam1917 5 жыл бұрын
His website is being blocked giving a message that it is malicious. (:
@SteveInFL
@SteveInFL 6 жыл бұрын
what a garbage recommendation, the file is full of viruses...
@grahammayor3192
@grahammayor3192 3 жыл бұрын
There are no viruses in the add-in and never have been.
Can You Draw A PERFECTLY Dotted Line?
00:55
Stokes Twins
Рет қаралды 104 МЛН
БОЛЬШОЙ ПЕТУШОК #shorts
00:21
Паша Осадчий
Рет қаралды 9 МЛН
Бездомный помог ребятам на дне рождения 🤯
0:39
Фильмы I Сериалы
Рет қаралды 3,6 МЛН
小天使和小丑离家出走#short #angel #clown
0:36
Super Beauty team
Рет қаралды 15 МЛН
Luggage to the Rear 🤣?! 2025 Porsche 911GTS Hybrid #shorts
0:20
thomas.letsgo
Рет қаралды 15 МЛН
berenang lagi #viral #shorts
0:12
Kakek Endo Family
Рет қаралды 45 МЛН