Auto-populate a word document with excel data

A short tutorial on how to pull data from an excel sheet into a word doc.
update: I made an error at 2:25 - you can only personalize each individual document once you merge, anything you write on the master document prior to merging will be present on each document you will create...
------------------------------
By Bandicam Screen Recorder (www.bandicam.com)

[@morstrategypartners1646]

FANTASTIC! This is LOTS simpler than the other 4 videos I saw on how to do this - THANK YOU!

[@adammathis8784]

Thank you very much. Worked perfectly. We run a training center and have 17 class rooms. If you have something different everyday that could mean 85 room assignments each week. My building manager was doing it individually. Huge time saver.

[@jameswaweru5234]

Just what I have been looking for. I could never thank you enough!

[@nigeldsa1]

May be you could increase the volume for your recordings. But great video. Saved me lots of time. Thanks a ton

[@shermilabdul1]

Thanks for this, very descriptive and time-saving.

[@tamialuster4666]

This was succinct and super helpful, thank you!

[@mileskirat]

Awesome! Thank you! I needed to know how to do this and found the solution so quickly :)

[@YuriFey-sw5jx]

This is really really good and solved my needs perfectly. Thank you thank you thank you!

[@tagpolice7265]

It took me aaaages to find this information, thank you so so much

[@HomeSchoolChannel]

Thanks a Ton.. This solved our biggest Problem

[@arbazbamboowala]

Thanks u saved alot of time of mine thanks alot

[@alanbroderick5243]

Thanks for the video tutorial. It works great my side ! I was just wondering if there was an automated way to save a different file for each student automatically, using, say, the surname as the filename, without having to manually save each page and type the name of the file you're saving ?

[@user-pp1wm5wl1j]

Thank you so much, it helped me a lot at my work

[@ShaiVardi]

Thank you for his video!!!!

[@juandavidquiceno8684]

Wow , Thank you sooooooo much.

[@CIA_Is_aTerrorist_Orginization]

Thanks for the video. You've already saved me hours of time. Just curious if I wanted to make 4 separate documents at once from your data set, would I just merge from 4 to 1 instead of 2 to 1?

[@ltalpacas6786]

You can create 1 PDF or word file with unlimited sheets, each pulling data from a row in the data set provided. In order to split that file with unlimited pages into separate docs google "how to split PDF files".

[@baruvenkatasukumar3939]

This is very useful information

[@rahuljadhav4883]

Really thank you soo much

[@Zaddygains]

Thanks so much!

[@mckevrock]

You just made my life a lot easier. THANK YOU!!

[@mahdyislam7178]

awesome ma'am! I'm searching this solution for a long time. thanks for thousand times! love from BANGLADESH...

[@noname5905]

Hi there, is it possible to use a similar method to have the same information, but all in one word document? Thanks!

[@rehanakhter1975]

Thank You

[@parthgupta8364]

Thanks a ton

[@ayanshgaming692]

wow, nice

[@Your-BestNightmare]

Can you use this to generate that document for all in a batch save vs. going one by one and saving? Ex... you have 4 students in your spreadsheet, batch process to create a document for all 4 at once vs. saving one at a time? Thanks! this is awesome

[@Blake-yh4um]

You can click the Finish & Merge, Print Documents, All, print to PDF. This batch creates them all in the one document.

[@westsunvisa]

How to show the data for the second row? Only in the first row data shows.

[@westsunvisa]

Got it now. Its besides the Show preview the one with left and right arrow, you have to choose what number of row.

[@abdullakooheji]

Thank you. What if I want to have multiple records in same page

[@elnelly16]

Thanks

[@TessHere]

Hi. Can I have it automatically print as well ? Thanks.

[@GrumpyOldMan9]

What do you do when you have to send this letter to 400 parents??

[@user-kr3hm5ym6k]

Lets say I have 100 rows in excel. How do I get 100 different pdfs files without clicking print for each one?

[@hemanthm9524]

This is mail merge

[@khurramshahzad9359]

It would be nice if you'd have spoken with energy

[@alexnail]

So rude, be respectful