Thank you so much! I've been searching for this but didn't know how to name it, and this is perfect
@time4sanity28 күн бұрын
I KNEW there was a way to do this. Thank you for the simple example. It clarified A LOT for me in designing my documents and merges!! Much appreciated.
@thomaticus7507Ай бұрын
Thank you so much for this!!!!! I remember trying to learn this many many years ago. never could do it. Now I needed to use this skill and found your video.
@rick-vista1612Ай бұрын
Kudos to you sir!
@username-oq1cc2 ай бұрын
Thanks a bunch, it took me while to find your video among all the one that are using 3rd party tools, plugins, etc. Much appreciated! I like your to-the-point style of explaining.
@marcuswagner89872 ай бұрын
FINALLY! THIS SOLVED
@thomasdavadant96332 ай бұрын
Merci !
@bhthllj2 ай бұрын
Great, no-bs explanation. Thanks a bunch!
@andrewligonfant3192 ай бұрын
You're welcome!
@mh.a40833 ай бұрын
That's great, i have a 400 students in my exel and and now i can easily give them their certificates. But isn't there a way to save all of them in individual word files?
@andrewligonfant3192 ай бұрын
I believe you should be able to generate individual word docs once you click on "finish and merge."
@user-cu8de7ip9d3 ай бұрын
this is the best tutorial ever... thank you
@andrewligonfant3192 ай бұрын
You're welcome!
@dvklaveren3 ай бұрын
When I try this, it replaces the merge fields with messages about the bookmark not being defined (I work in a Dutch company, so the error is shown in Dutch). Why would that happen?
@andrewligonfant3192 ай бұрын
I'm sorry I don't think I know the answer to this one.
@MosquitoBait3 ай бұрын
Thanks a million
@andrewligonfant3192 ай бұрын
You're welcome!
@morarucosmin67763 ай бұрын
Dude, your volume is allmost zero. But yes, informative :)
@andrewligonfant3192 ай бұрын
Volume sounds just fine on my end!
@JustGwen054 ай бұрын
THANKS FOR THIS - 😅
@andrewligonfant3192 ай бұрын
Any time!
@asvyoutube4 ай бұрын
How do you customise the names of the files created
@lawrencekoestler7424 ай бұрын
Thanks for the video. Just what I needed.
@andrewligonfant3192 ай бұрын
You're welcome!
@benoit73424 ай бұрын
Thank you for this vidéo!❤
@andrewligonfant3192 ай бұрын
You're so welcome!
@aaronjudesaldanha56884 ай бұрын
this is amazing - thanks for sharing
@sheezy19795 ай бұрын
Amazing! Found the solution thanks to you!
@murtadaalrubaie23795 ай бұрын
That was truly very helpful
@denise.davis-probaterealtor5 ай бұрын
Thank you!
@imsmilen35 ай бұрын
4 years after posting and still helping people!! Thank you!
@EtchTzy5 ай бұрын
Thanks
@thebrokencode145136 ай бұрын
Is there a way to automatically add more pages in Word with each page containing the same template, but with each info from the Excel sheet?
@andrewligonfant3192 ай бұрын
I'm sorry I'm not sure I understand the question.
@thebrokencode145132 ай бұрын
@@andrewligonfant319 Like duplicate the same page with the same contents in the same document
@luisabbott24696 ай бұрын
😁 Promo-SM
@izzetalev20247 ай бұрын
@Andrew Ligon Fant, many thanks, was indeed very helpful. Quick question: I would like to save each word document for 'John' and then 'Jane' in your case. What do I need to do then ?
@user-cc4lo4uf7l7 ай бұрын
Good
@GregVirgoe7 ай бұрын
Can you use this same technique for creating standard letters from a selection of pre-written paragraphs?
@andrewligonfant3197 ай бұрын
Of course! In fact, I've used this to do that exact thing.
@GregVirgoe7 ай бұрын
@@andrewligonfant319 do you have a video on that ?
@Crunch6304 ай бұрын
Just use common sense dude. IF formulas and writing long sentences as the cell values.
@jeannepedigo77927 ай бұрын
Great teacher! I have listened to all four videos and would enjoy more.
@andrewligonfant3197 ай бұрын
Thank you!
@ProfeARios7 ай бұрын
Thank you for sharing. Best regards from Panama 🇵🇦
@andrewligonfant3197 ай бұрын
Cheers!
@user-bw7vs3db3r8 ай бұрын
i am moving over currency values and it does not format correctly to word. no commas and more than 2 decimal. how do we format the word document
@andrewligonfant3197 ай бұрын
I'm not sure I have the answer, but I bet someone does!
@jamesashmead63088 ай бұрын
Can you do this in Outlook rather than Word?
@andrewligonfant3197 ай бұрын
Not that I'm aware of. Sorry.
@maliduhettiarachchi22068 ай бұрын
I was struggling for days . Thank you so much
@andrewligonfant3197 ай бұрын
Happy to help!
@user-ks5gf5vb5m8 ай бұрын
Great...but it works not for first 50 entries
@marianamarquezsital24179 ай бұрын
I have about 72 different rows of information to fill on a word template. Once I have the final templates filled in is there a way to save individual templates vs all 72 on one document? Thank you.
@marryme74789 ай бұрын
내가 찾던 자동화 방법 입니다 감사합니다.
@Aquanick849 ай бұрын
This is so excellent. Thank you!!!
@andrewligonfant3197 ай бұрын
You're welcome!
@jdasbkb9 ай бұрын
nice, simple and straight to direction
@BABA-is8kv9 ай бұрын
Your awesome! Thank you!
@andrewligonfant3197 ай бұрын
You're welcome!
@kevinbyers735910 ай бұрын
I know this is an older video. Is there a way that I can fill down instead of per sheet? As I am trying to use it to send need dates to a vendor. Thanks in advance.
@user-fi6nd5ul8z10 ай бұрын
What if I need to add multiple entries from the same list in one excel document. What I mean is if I insert a merge field twice for eg. "Name" and I need two different names to show up under one word document.. is it possible?
@kilo03twenty11 ай бұрын
Straight to the point and easy to follow. Thank you.
@nanioushka Жыл бұрын
Omg thank you SOOOOO much for this!!!!!!
@camillamason2505 Жыл бұрын
This just changed my life. THANK YOU!!
@LepeOa Жыл бұрын
I tried to lookup a video for days that explained this in a simple way like this! Thank you soooo much
@mkate1947 Жыл бұрын
Hi, is this possible only for one section at a time? I have a word template with repetitive pages, but page is tied to a specific person. How do I automatic this so each row populates on a seperate page? Does that make sense?
@pradeepmishra3249 Жыл бұрын
DEAR SIR I USUALY TO MAKE REPORTS OF CLAIM INVESTIGATION OF TP AND OD CLAIMS. IT TAKES TOO MUCH TIME TO COMPLETE ON WORD IS THEIR ANY SUCH SHORT CUTS WHERE I FILL THE DETAILS OF THE CASE AND MY REPORTS GET READY AUTOMATICALLY... PLEASE HELP
@didiervalley6704 Жыл бұрын
Andrew from France Mille mercis pour ce tuto qui correspond à mon attente et que je cherche depuis un bout de temps!
@nishim7169 Жыл бұрын
Hi Andrew, jst a quick query... Once I click on finish and merge, my word is getting created but with horizontal lines at each step.. Is there a way I can remove those in settings prior or so?? Thanks
@andrewligonfant3192 ай бұрын
Not sure why that was happening. Did you figure it out?