Тёмный
Andrew Ligon Fant
Andrew Ligon Fant
Andrew Ligon Fant
Подписаться
Комментарии
@martincarbonell7032
@martincarbonell7032 7 дней назад
Finally real automation between Excel and Word. Cell by Cell. Thank you !
@buzoreyes
@buzoreyes 16 дней назад
Most useful
@johnarmarego8940
@johnarmarego8940 Месяц назад
great presentation exactly what I needed
@AudreMcNutt
@AudreMcNutt Месяц назад
Thank you so much! I've been searching for this but didn't know how to name it, and this is perfect
@time4sanity
@time4sanity Месяц назад
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
@thomaticus7507 2 месяца назад
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
@rick-vista1612 2 месяца назад
Kudos to you sir!
@username-oq1cc
@username-oq1cc 3 месяца назад
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.
@marcuswagner8987
@marcuswagner8987 3 месяца назад
FINALLY! THIS SOLVED
@thomasdavadant9633
@thomasdavadant9633 3 месяца назад
Merci !
@bhthllj
@bhthllj 3 месяца назад
Great, no-bs explanation. Thanks a bunch!
@andrewligonfant319
@andrewligonfant319 3 месяца назад
You're welcome!
@mh.a4083
@mh.a4083 4 месяца назад
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?
@andrewligonfant319
@andrewligonfant319 3 месяца назад
I believe you should be able to generate individual word docs once you click on "finish and merge."
@user-cu8de7ip9d
@user-cu8de7ip9d 4 месяца назад
this is the best tutorial ever... thank you
@andrewligonfant319
@andrewligonfant319 3 месяца назад
You're welcome!
@dvklaveren
@dvklaveren 4 месяца назад
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?
@andrewligonfant319
@andrewligonfant319 3 месяца назад
I'm sorry I don't think I know the answer to this one.
@MosquitoBait
@MosquitoBait 4 месяца назад
Thanks a million
@andrewligonfant319
@andrewligonfant319 3 месяца назад
You're welcome!
@morarucosmin6776
@morarucosmin6776 4 месяца назад
Dude, your volume is allmost zero. But yes, informative :)
@andrewligonfant319
@andrewligonfant319 3 месяца назад
Volume sounds just fine on my end!
@JustGwen05
@JustGwen05 5 месяцев назад
THANKS FOR THIS - 😅
@andrewligonfant319
@andrewligonfant319 3 месяца назад
Any time!
@asvyoutube
@asvyoutube 5 месяцев назад
How do you customise the names of the files created
@lawrencekoestler742
@lawrencekoestler742 5 месяцев назад
Thanks for the video. Just what I needed.
@andrewligonfant319
@andrewligonfant319 3 месяца назад
You're welcome!
@benoit7342
@benoit7342 5 месяцев назад
Thank you for this vidéo!❤
@andrewligonfant319
@andrewligonfant319 3 месяца назад
You're so welcome!
@aaronjudesaldanha5688
@aaronjudesaldanha5688 5 месяцев назад
this is amazing - thanks for sharing
@sheezy1979
@sheezy1979 6 месяцев назад
Amazing! Found the solution thanks to you!
@murtadaalrubaie2379
@murtadaalrubaie2379 6 месяцев назад
That was truly very helpful
@denise.davis-probaterealtor
@denise.davis-probaterealtor 6 месяцев назад
Thank you!
@imsmilen3
@imsmilen3 6 месяцев назад
4 years after posting and still helping people!! Thank you!
@EtchTzy
@EtchTzy 6 месяцев назад
Thanks
@thebrokencode14513
@thebrokencode14513 7 месяцев назад
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?
@andrewligonfant319
@andrewligonfant319 3 месяца назад
I'm sorry I'm not sure I understand the question.
@thebrokencode14513
@thebrokencode14513 3 месяца назад
@@andrewligonfant319 Like duplicate the same page with the same contents in the same document
@luisabbott2469
@luisabbott2469 7 месяцев назад
😁 Promo-SM
@izzetalev2024
@izzetalev2024 8 месяцев назад
@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-cc4lo4uf7l
@user-cc4lo4uf7l 8 месяцев назад
Good
@GregVirgoe
@GregVirgoe 8 месяцев назад
Can you use this same technique for creating standard letters from a selection of pre-written paragraphs?
@andrewligonfant319
@andrewligonfant319 8 месяцев назад
Of course! In fact, I've used this to do that exact thing.
@GregVirgoe
@GregVirgoe 8 месяцев назад
@@andrewligonfant319 do you have a video on that ?
@Crunch630
@Crunch630 5 месяцев назад
Just use common sense dude. IF formulas and writing long sentences as the cell values.
@jeannepedigo7792
@jeannepedigo7792 8 месяцев назад
Great teacher! I have listened to all four videos and would enjoy more.
@andrewligonfant319
@andrewligonfant319 8 месяцев назад
Thank you!
@ProfeARios
@ProfeARios 8 месяцев назад
Thank you for sharing. Best regards from Panama 🇵🇦
@andrewligonfant319
@andrewligonfant319 8 месяцев назад
Cheers!
@user-bw7vs3db3r
@user-bw7vs3db3r 9 месяцев назад
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
@andrewligonfant319
@andrewligonfant319 8 месяцев назад
I'm not sure I have the answer, but I bet someone does!
@jamesashmead6308
@jamesashmead6308 9 месяцев назад
Can you do this in Outlook rather than Word?
@andrewligonfant319
@andrewligonfant319 8 месяцев назад
Not that I'm aware of. Sorry.
@maliduhettiarachchi2206
@maliduhettiarachchi2206 9 месяцев назад
I was struggling for days . Thank you so much
@andrewligonfant319
@andrewligonfant319 8 месяцев назад
Happy to help!
@user-ks5gf5vb5m
@user-ks5gf5vb5m 9 месяцев назад
Great...but it works not for first 50 entries
@marianamarquezsital2417
@marianamarquezsital2417 10 месяцев назад
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.
@marryme7478
@marryme7478 10 месяцев назад
내가 찾던 자동화 방법 입니다 감사합니다.
@Aquanick84
@Aquanick84 10 месяцев назад
This is so excellent. Thank you!!!
@andrewligonfant319
@andrewligonfant319 8 месяцев назад
You're welcome!
@jdasbkb
@jdasbkb 10 месяцев назад
nice, simple and straight to direction
@BABA-is8kv
@BABA-is8kv 10 месяцев назад
Your awesome! Thank you!
@andrewligonfant319
@andrewligonfant319 8 месяцев назад
You're welcome!
@kevinbyers7359
@kevinbyers7359 11 месяцев назад
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-fi6nd5ul8z
@user-fi6nd5ul8z 11 месяцев назад
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?
@kilo03twenty
@kilo03twenty Год назад
Straight to the point and easy to follow. Thank you.
@nanioushka
@nanioushka Год назад
Omg thank you SOOOOO much for this!!!!!!
@camillamason2505
@camillamason2505 Год назад
This just changed my life. THANK YOU!!
@LepeOa
@LepeOa Год назад
I tried to lookup a video for days that explained this in a simple way like this! Thank you soooo much
@mkate1947
@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
@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