How to fill word documents from Excel. This could be useful for mass mailings or for forms that you need to fill out repeatedly - and you won't have to use VBA.
Пікірлер: 152
@imsmilen35 ай бұрын
4 years after posting and still helping people!! Thank you!
@maizuva64912 жыл бұрын
Dude - I spent literally hours looking for this. People talking about legacy text boxes and whatnot, and in 4 minutes boom. sorted.
@codylane25043 жыл бұрын
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.
@HotButteredCorn2 жыл бұрын
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.
@time4sanity26 күн бұрын
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.
@ellurgomti2 жыл бұрын
Thank you. You saved almost a day's work. I completed in 2 hrs. Excellent video. Easy to understand and execute.
@gagandeepchani21693 жыл бұрын
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 ! 😊
@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.
@LepeOa Жыл бұрын
I tried to lookup a video for days that explained this in a simple way like this! Thank you soooo much
@brentmillercopywriting3 жыл бұрын
This was so helpful, especially grabbing the recipients from the excell file you are using. So cool!
@86smcneil2 жыл бұрын
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!
@camillamason2505 Жыл бұрын
This just changed my life. THANK YOU!!
@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.
@kilo03twenty11 ай бұрын
Straight to the point and easy to follow. Thank you.
@DrMadisenHarper3 жыл бұрын
Thanks so much for sharing your knowledge. You've saved me SO MUCH TIME with re-entering duplicate data in forms. Appreciate it!
@noahjagger11122 жыл бұрын
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
@ProfeARios3 жыл бұрын
Thank you so much for your help!!!!! Blessings!!!! You are a lifesaver!!!! Regards from the Republic of Panama!!!!
@AudreMcNutt3 күн бұрын
Thank you so much! I've been searching for this but didn't know how to name it, and this is perfect
@didiervalley6704 Жыл бұрын
Andrew from France Mille mercis pour ce tuto qui correspond à mon attente et que je cherche depuis un bout de temps!
@anilmutlu3 жыл бұрын
Thank you man. You saved my life. God bless you.
@RelayerBob Жыл бұрын
Thank you, that was super clear and easy to follow. Worked perfectly.
@candacesherman31823 жыл бұрын
Thank you so much for making this easy to understand!!!!! You made my night~ have a great weekend!
@jawadahmadakhter82532 жыл бұрын
Thanks Andrew. Easiest way to automate word
@elizabethc75192 жыл бұрын
Simple but good. It is the most straight forward video of how to add excel data to work. Thanks.
@joelbergan67833 жыл бұрын
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.
@TristanMaxwell2 жыл бұрын
Thank you so much for this video, this was so straightforward and easy to do ❤
@drknockers3 жыл бұрын
Thanks! This is going to cut hours out of my work day
@bencoxmail2 жыл бұрын
great vid! quick and to the point. thanks!!
@James-T-Kirk2 жыл бұрын
Great tip. This was very helpful. Thank you.
@murtadaalrubaie23795 ай бұрын
That was truly very helpful
@maureenbrown5651 Жыл бұрын
Thank you, I was able to follow your instructions and it worked.
@chupitrompi5614 Жыл бұрын
you are a soldier, great content and straight to the point, subscribed and thanks my friend
@jdasbkb9 ай бұрын
nice, simple and straight to direction
@sheezy19795 ай бұрын
Amazing! Found the solution thanks to you!
@bhthllj2 ай бұрын
Great, no-bs explanation. Thanks a bunch!
@andrewligonfant3192 ай бұрын
You're welcome!
@maliduhettiarachchi22068 ай бұрын
I was struggling for days . Thank you so much
@andrewligonfant3197 ай бұрын
Happy to help!
@SherriAI Жыл бұрын
that worked like a charm. thank you
@user-cu8de7ip9d3 ай бұрын
this is the best tutorial ever... thank you
@andrewligonfant3192 ай бұрын
You're welcome!
@DeanneR3 жыл бұрын
this was very helpful thank you
@lawrencekoestler7424 ай бұрын
Thanks for the video. Just what I needed.
@andrewligonfant3192 ай бұрын
You're welcome!
@Technicalvidz3 жыл бұрын
Great Great Great and fantastic, Thank you so much Sir
@banolswt89773 жыл бұрын
Andrew Fant, that is awesome👍
@AmrateMoustafa Жыл бұрын
Thank you. That was very helpful!
@carsloversintherealandgami8116 Жыл бұрын
thanks so much i don't know how can i thank you you are the best i love you
@Aquanick849 ай бұрын
This is so excellent. Thank you!!!
@andrewligonfant3197 ай бұрын
You're welcome!
@rick-vista1612Ай бұрын
Kudos to you sir!
@beurjess2 жыл бұрын
Thank u for the info, this is what I need 😍 ..
@marryme74789 ай бұрын
내가 찾던 자동화 방법 입니다 감사합니다.
@marcuswagner89872 ай бұрын
FINALLY! THIS SOLVED
@user-zm3kx4bl6k2 жыл бұрын
Thank you so much for this video.
@andrewligonfant319 Жыл бұрын
Afwan.
@denise.davis-probaterealtor5 ай бұрын
Thank you!
@affandyyy3 жыл бұрын
Now I can use this for the rest of my life
@benoit73424 ай бұрын
Thank you for this vidéo!❤
@andrewligonfant3192 ай бұрын
You're so welcome!
@MrLeoprovodnik3 жыл бұрын
Thank you MUCH!
@arianerose04 Жыл бұрын
Superhelful! Thank you.
@mohdimranyusof28892 жыл бұрын
Fantastic. tq very much.
@ZombieRofl3 жыл бұрын
YES this works
@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.
@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 ?
@ankitaaasiiiiiii3 жыл бұрын
Thank you so much!
@baddanerachid8909 Жыл бұрын
THANKS A LOT BRO
@BABA-is8kv9 ай бұрын
Your awesome! Thank you!
@andrewligonfant3197 ай бұрын
You're welcome!
@rasithlakshan9101 Жыл бұрын
excellent , and thanks
@abhishekmenon1101 Жыл бұрын
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?
@EtchTzy5 ай бұрын
Thanks
@MosquitoBait3 ай бұрын
Thanks a million
@andrewligonfant3192 ай бұрын
You're welcome!
@thomasdavadant96332 ай бұрын
Merci !
@acaciomagalhaes954 Жыл бұрын
Really nice video. But a question, can I link the Word with a file stored at MS Teams?
@saumilshah69263 жыл бұрын
Can we generate this from multiple columns to multiple letters??
@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.
@sonalshandilya3977 Жыл бұрын
How to create the headers vertical instead of horizontal?
@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?
@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?
@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.
@lydiayang34742 жыл бұрын
If I change the heading itself, how could it be reflected on insert merge field? Thanks
@brianrosenstein72902 жыл бұрын
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 Жыл бұрын
No - the data only goes one way.
@altostrata70182 жыл бұрын
Hello, is there a way I can put the field codes for each field in a Word template and complete documents from different Excel sheets by editing the field code pointing at the Excel file and sheet?
@andrewligonfant319 Жыл бұрын
I don't think so, but let us know if you figure it out!
@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?
@DesignReady.2 жыл бұрын
What if I want to skip the empty cells
@waheedsaifi16682 жыл бұрын
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?
@mrahhmedable7 ай бұрын
Did you find a solution?
@user-cc4lo4uf7l7 ай бұрын
Good
@reem-pw8um2 жыл бұрын
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.
@ihabal-mafradji98542 жыл бұрын
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
@mrahhmedable7 ай бұрын
Hi. Did you find a solution to this?
@neekeshpradhan89573 жыл бұрын
buddy, how did you get that black colored interface in Excel? I have only white or dark gray?
@andrewligonfant319 Жыл бұрын
I have no idea - maybe it's a mac thing?
@JustGwen054 ай бұрын
THANKS FOR THIS - 😅
@andrewligonfant3192 ай бұрын
Any time!
@michaelkrue45282 жыл бұрын
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 Жыл бұрын
I'm sorry to disappoint.
@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
@scooble2 жыл бұрын
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. Жыл бұрын
Yes it is possible
@andrewligonfant319 Жыл бұрын
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 Жыл бұрын
@@andrewligonfant319 . ...but can you tell the data validation list to get its source data.from an array populated from a.Microsoft Word table?
@rachelbarney94932 жыл бұрын
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 Жыл бұрын
Would putting the dollar sign into the Word template work?
@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!
@kevinrosenberg87953 жыл бұрын
so lets say im making multiple word documents that all need to be named can that be done without vba ?
@andrewligonfant3193 жыл бұрын
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.
@BILL_BO_jangles2 жыл бұрын
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_jangles2 жыл бұрын
@@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).
@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."
@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?
@lorenzoechevarria87112 жыл бұрын
You need to have the paid version of Microsoft office to be able to perform this correct?
@andrewligonfant319 Жыл бұрын
I don't know.
@thebrokencode145135 ай бұрын
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
@granand2 жыл бұрын
Hi Andrew, Can I create multiple templates simultaneously from excel cells to word
@andrewligonfant319 Жыл бұрын
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 Жыл бұрын
@@andrewligonfant319 Sorted the next day, I ran several iterations.
@granand Жыл бұрын
@@andrewligonfant319 Thank you very much.
@charlesrowley16573 жыл бұрын
So is there a way to save a template(word) in which you could just type in 1 field()like a customers name) and the rest would autofill?
@andrewligonfant3193 жыл бұрын
I’m really not the guy to answer that question, but I hope someone does. I think it’s doable but without more specifics it’s hard to say.
@Wolfdaze2 жыл бұрын
@@andrewligonfant319 You can search for any of the fields in Word under the Mailings tab
@shadynasty40263 жыл бұрын
mail merge sucks, was hoping this was about the new embedded "automate" feature which works across word, excel, and PP
@andrewligonfant3193 жыл бұрын
Sorry to disappoint.
@SupraJin3 жыл бұрын
That's a great alternative to pasting links one by one! Do you have any alternative ideas on how to do so when both documents are saved on sharepoint, or a VPN? From excel to power point it works perfectly, but word completely messes it up
@andrewligonfant3193 жыл бұрын
I’m sorry I don’t have an answer for you. I am not an expert at this. I just had to figure this problem out and noticed there weren’t good videos on it so I decided to share the knowledge.
@SupraJin3 жыл бұрын
@@andrewligonfant319 Thanks for the answer! I really looked it up, even called Microsoft 365 support, and they said it is not recomended to work with online documents this way. They call it "customizing the use of MS Office" and so it may work or not, but they don't offer the support for that kind of process when the files are not stored on local drivers. Thanks again, anyway!
@SupraJin3 жыл бұрын
They only recommended trying to use the power automate suite.
@andrewligonfant3193 жыл бұрын
@@SupraJin it’s unfortunate that they discourage custom use of their platform.