Dude - I spent literally hours looking for this. People talking about legacy text boxes and whatnot, and in 4 minutes boom. sorted.
@codylane2504
3 жыл бұрын
Simple, straight to the point, no complicated macros. Really helped me when I had a project that had a bunch of labels and I didn't want to fill in the fields individually.
@time4sanity
3 ай бұрын
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
3 ай бұрын
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.
@martincarbonell7032
2 ай бұрын
Finally real automation between Excel and Word. Cell by Cell. Thank you !
@gagandeepchani2169
3 жыл бұрын
I have watched a couple of videos and most of them are worth watching but this one from Andrew is found best among these all... Thank you ! 😊
@camillamason2505
Жыл бұрын
This just changed my life. THANK YOU!!
@86smcneil
2 жыл бұрын
EXACTLY what I was looking for. I haven't tried it yet, however, with your excellent teaching ability I feel like I will be able to do just what I needed. Thank!
@ProfeARios
3 жыл бұрын
Thank you so much for your help!!!!! Blessings!!!! You are a lifesaver!!!! Regards from the Republic of Panama!!!!
@drknockers
3 жыл бұрын
Thanks! This is going to cut hours out of my work day
@brentmillercopywriting
3 жыл бұрын
This was so helpful, especially grabbing the recipients from the excell file you are using. So cool!
@GregVirgoe
10 ай бұрын
Can you use this same technique for creating standard letters from a selection of pre-written paragraphs?
@andrewligonfant319
10 ай бұрын
Of course! In fact, I've used this to do that exact thing.
@GregVirgoe
10 ай бұрын
@@andrewligonfant319 do you have a video on that ?
@Crunch630
7 ай бұрын
Just use common sense dude. IF formulas and writing long sentences as the cell values.
@RelayerBob
Жыл бұрын
Thank you, that was super clear and easy to follow. Worked perfectly.
@imsmilen3
8 ай бұрын
4 years after posting and still helping people!! Thank you!
@EricLiu-SDAT
6 ай бұрын
this is the best tutorial ever... thank you
@andrewligonfant319
5 ай бұрын
You're welcome!
@Allen.N.Humphries
22 күн бұрын
I thought I finally had what I needed, but when I clicked preview results, the date Excel displays as Tuesday, December 31, 2024 displays in Word as 2024-12-31. I need the display to be the same format. It appears that all that links is the serial number of the date.
@anilmutlu
3 жыл бұрын
Thank you man. You saved my life. God bless you.
@excel_lent9372
11 күн бұрын
Hey Bro I don't know would you read my comment or not. But I really wanna say thanks to you. It helped me so much. I appreciate it bro. Thanks so much. I subscribed your channel and press like button.
@izzetalev2024
9 ай бұрын
@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 ?
@sheezy1979
8 ай бұрын
Amazing! Found the solution thanks to you!
@NahlaGarmo
11 ай бұрын
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
10 ай бұрын
I'm not sure I have the answer, but I bet someone does!
@rachelbarney9493
2 жыл бұрын
This is great info but I have ran into a dilemma. I have a formula in excel that needs to show the dollar amount in word but it is not in currency: can that be fixed?
@andrewligonfant319
2 жыл бұрын
Would putting the dollar sign into the Word template work?
@elizabethc7519
3 жыл бұрын
Simple but good. It is the most straight forward video of how to add excel data to work. Thanks.
@affandyyy
3 жыл бұрын
Now I can use this for the rest of my life
@DesignReady.
2 жыл бұрын
What if I want to skip the empty cells
@maureenbrown5651
2 жыл бұрын
Thank you, I was able to follow your instructions and it worked.
@johnarmarego8940
2 ай бұрын
great presentation exactly what I needed
@ihabal-mafradji9854
2 жыл бұрын
Thanks for the help! How can I keep the formatting of the excel cells into the inserted word fields? For example I have a cell format as finance (€ 1.000.000,00) and when I follow all steps I get 1000000 as an amount
@mrahhmedable
10 ай бұрын
Hi. Did you find a solution to this?
@marianamarquezsital2417
Жыл бұрын
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.
@murtadaalrubaie2379
8 ай бұрын
That was truly very helpful
@kevinbyers7359
Жыл бұрын
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.
@brianrosenstein7290
3 жыл бұрын
Awesome Vid. Thanks. If I need to make changes to the data would I be able to do this through Word? Does the data flow in both directions?
@andrewligonfant319
2 жыл бұрын
No - the data only goes one way.
@reem-pw8um
2 жыл бұрын
How do you print the entire list? I have 120 peoples names/address in my letter mailing list but when I click print it is only printing the person I am looking at.
@mh.a4083
6 ай бұрын
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
5 ай бұрын
I believe you should be able to generate individual word docs once you click on "finish and merge."
@xnicksomox
Жыл бұрын
Is there a way to generate the PDFs with unique names? possibly even using the fields from the excel spreadsheet? Right now it just sends it as PDFMailer as the attachment name and saves them that way
@rodfaz7
Жыл бұрын
Helllo. thank you for the video. Is there a way to choose from a list not just 1 or 2? To see the actual name of what you are autofilling?
@sonalshandilya3977
2 жыл бұрын
How to create the headers vertical instead of horizontal?
@banolswt8977
4 жыл бұрын
Andrew Fant, that is awesome👍
@dvklaveren
6 ай бұрын
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
5 ай бұрын
I'm sorry I don't think I know the answer to this one.
@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?
@Technicalvidz
3 жыл бұрын
Great Great Great and fantastic, Thank you so much Sir
@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
@TheSharpStalwart
8 ай бұрын
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
5 ай бұрын
I'm sorry I'm not sure I understand the question.
@TheSharpStalwart
5 ай бұрын
@@andrewligonfant319 Like duplicate the same page with the same contents in the same document
@AmrateMoustafa
2 жыл бұрын
Thank you. That was very helpful!
@beurjess
2 жыл бұрын
Thank u for the info, this is what I need 😍 ..
@saumilshah6926
3 жыл бұрын
Can we generate this from multiple columns to multiple letters??
@SherriAI
Жыл бұрын
that worked like a charm. thank you
@عبيدأحمدلتعليمالبناءوالهندسةال
2 жыл бұрын
Thank you so much for this video.
@andrewligonfant319
2 жыл бұрын
Afwan.
@denise.davis-probaterealtor
8 ай бұрын
Thank you!
@marcuswagner8987
5 ай бұрын
FINALLY! THIS SOLVED
@neekeshpradhan8957
3 жыл бұрын
buddy, how did you get that black colored interface in Excel? I have only white or dark gray?
@andrewligonfant319
2 жыл бұрын
I have no idea - maybe it's a mac thing?
@kevinrosenberg8795
3 жыл бұрын
so lets say im making multiple word documents that all need to be named can that be done without vba ?
@andrewligonfant319
3 жыл бұрын
I’m not sure if I understand, but I think you mean the file name. If you’re on a Mac, you may be able to work some magic with keyboard maestro, and if you’re on pc you may be able to do that with power automate. But yeah sorry I don’t have an exact answer for you.
@ZombieRofl
3 жыл бұрын
YES this works
@buzoreyes
2 ай бұрын
Most useful
@JustGwen05
6 ай бұрын
THANKS FOR THIS - 😅
@andrewligonfant319
5 ай бұрын
Any time!
@ankitaaasiiiiiii
3 жыл бұрын
Thank you so much!
@baddanerachid8909
Жыл бұрын
THANKS A LOT BRO
@lexiemulhern7207
3 жыл бұрын
Is there a way to keep the column title with the data it belongs to? So for example, “NAME: John Smith” rather than it just saying “John smith”. Some of the data Im trying to extract will be confusing without the context of the title to go along with it
@thomasdavadant9633
5 ай бұрын
Merci !
@HotButteredCorn
2 жыл бұрын
Thank you! I have been beating myself up black and blue for HOURS trying to take very specific Excel fields and merge them into differnt places in a word doc. WOW. And then ... I stumble into your solution. Well done. Lean / clean / straightforward. Thanks.
@brunotessidor7431
3 жыл бұрын
Thank you!
@LepeOa
Жыл бұрын
I tried to lookup a video for days that explained this in a simple way like this! Thank you soooo much
@carsloversintherealandgami8116
Жыл бұрын
thanks so much i don't know how can i thank you you are the best i love you
@gagandeepchani2169
3 жыл бұрын
I have watched a couple of videos and most of them are worth watching but this one from Andrew is found best among these all... Thank you ! 😊
@EtchTzy
8 ай бұрын
Thanks
@DeanneR
3 жыл бұрын
this was very helpful thank you
@didiervalley6704
Жыл бұрын
Andrew from France Mille mercis pour ce tuto qui correspond à mon attente et que je cherche depuis un bout de temps!
@James-T-Kirk
2 жыл бұрын
Great tip. This was very helpful. Thank you.
@jawadahmadakhter8253
2 жыл бұрын
Thanks Andrew. Easiest way to automate word
@jdasbkb
Жыл бұрын
nice, simple and straight to direction
@mohdimranyusof2889
3 жыл бұрын
Fantastic. tq very much.
@scooble
2 жыл бұрын
Is it possible to create a drop down list, that contains all the names, and when you select whichever name, the fields for "date", "location" shows the date and location for the corresponding name?
@DesignReady.
2 жыл бұрын
Yes it is possible
@andrewligonfant319
2 жыл бұрын
You can create drop-down lists in the Data Validation tab, and then you could auto-populate the other cells using a LOOKUP function to find the data from another table. Kind of complicated, but it could work.
@scooble
2 жыл бұрын
@@andrewligonfant319 . ...but can you tell the data validation list to get its source data.from an array populated from a.Microsoft Word table?
@GouravSharma-k6s
11 ай бұрын
Great...but it works not for first 50 entries
@bencoxmail
2 жыл бұрын
great vid! quick and to the point. thanks!!
@BILL_BO_jangles
2 жыл бұрын
The only problem I have with this process is that there seems to be a data limit that can be pulled from Excel. So basically, if you have a cell with a lot of information such as a paragraph or several paragraphs it wont pull all of it over to the word document.
@DesignReady.
2 жыл бұрын
Then what should I do
@BILL_BO_jangles
2 жыл бұрын
@@DesignReady. It depends on what your trying to import into the document. Excel limits you to 255 characters. That includes spaces and punctuation. If you want to import a large paragraph or several paragraphs you could break them up into columns with 255 character or less. Then you can tag the document in away that allows you to import the paragraph pieces chronologically. If you want to know how many characters are in each cell you can use =LEN(select cell).
@MrLeoprovodnik
3 жыл бұрын
Thank you MUCH!
@deusexxi8426
2 жыл бұрын
Thank you!
@bhthllj
5 ай бұрын
Great, no-bs explanation. Thanks a bunch!
@andrewligonfant319
5 ай бұрын
You're welcome!
@kilo03twenty
Жыл бұрын
Straight to the point and easy to follow. Thank you.
@alonsovivarsierra8400
Ай бұрын
Helped a lot thanks
@lawrencekoestler742
7 ай бұрын
Thanks for the video. Just what I needed.
@andrewligonfant319
5 ай бұрын
You're welcome!
@maliduhettiarachchi2206
11 ай бұрын
I was struggling for days . Thank you so much
@andrewligonfant319
10 ай бұрын
Happy to help!
@ellurgomti
2 жыл бұрын
Thank you. You saved almost a day's work. I completed in 2 hrs. Excellent video. Easy to understand and execute.
@KevinWadia
Жыл бұрын
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?
@AudreMcNutt
3 ай бұрын
Thank you so much! I've been searching for this but didn't know how to name it, and this is perfect
@DrMadisenHarper
3 жыл бұрын
Thanks so much for sharing your knowledge. You've saved me SO MUCH TIME with re-entering duplicate data in forms. Appreciate it!
@noahjagger1112
3 жыл бұрын
Sorry to be so offtopic but does anybody know of a method to get back into an instagram account..? I somehow forgot the password. I love any tips you can offer me
@rick-vista1612
4 ай бұрын
Kudos to you sir!
@Aquanick84
Жыл бұрын
This is so excellent. Thank you!!!
@andrewligonfant319
10 ай бұрын
You're welcome!
@joelbergan6783
3 жыл бұрын
Sorry to dead head an older vid, but THANK YOU. You saved me so much work of manually copy/pasting the results of an o365 form. (As far as I can find you can't automate the form results into word with previous form submissions, the only trigger in flow/automate is for new form submissions ******** M$) THANK YOU.
@BABA-is8kv
Жыл бұрын
Your awesome! Thank you!
@andrewligonfant319
10 ай бұрын
You're welcome!
@TristanMaxwell
2 жыл бұрын
Thank you so much for this video, this was so straightforward and easy to do ❤
@granand
2 жыл бұрын
Hi Andrew, Can I create multiple templates simultaneously from excel cells to word
@andrewligonfant319
2 жыл бұрын
I think so. You would just have to point each template to the Excel file. I haven't tried it, but I can't think of any reason why it wouldn't work.
@granand
2 жыл бұрын
@@andrewligonfant319 Sorted the next day, I ran several iterations.
@granand
2 жыл бұрын
@@andrewligonfant319 Thank you very much.
@acaciomagalhaes954
Жыл бұрын
Really nice video. But a question, can I link the Word with a file stored at MS Teams?
@lydiayang3474
2 жыл бұрын
If I change the heading itself, how could it be reflected on insert merge field? Thanks
@ElyonSolutions-n2j
10 ай бұрын
Good
@michaelkrue4528
3 жыл бұрын
All these kinds of videos talk about mail merge. I'm interested in merging the database into a document that is a listing of the entire database on as many sheets as necessary, printing to a document for output to the printer when called for. In other words all "A" names would be on page 1 for a basic example. All I see is one record to a document.
@andrewligonfant319
2 жыл бұрын
I'm sorry to disappoint.
@benoit7342
7 ай бұрын
Thank you for this vidéo!❤
@andrewligonfant319
5 ай бұрын
You're so welcome!
@abhishekmenon1101
2 жыл бұрын
Hi Andrew, what if we want to use data from multiple workbooks, or multiple sheets in a workbook? how do we merge data from multiple lists?
@chupitrompi5614
2 жыл бұрын
you are a soldier, great content and straight to the point, subscribed and thanks my friend
@waheedsaifi1668
2 жыл бұрын
Hi, how can I set up a formatting and style for different part of the word document (for example heading, bold times new roman 28, body text calibry 10, footnote calibry 8, table justied calibry 8 etc) in away when you paste sentences with different font, size, etc, it automatically changes to the default style set for that part of the document and one doesn't have to change it manually?
Пікірлер: 158