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)

[@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.

[@morstrategypartners1646]

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

[@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

[@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 ?

[@shermilabdul1]

Thanks for this, very descriptive and time-saving.

[@tamialuster4666]

This was succinct and super helpful, thank you!

[@AChapstickOrange]

You are a GOD. Thank you so much!

[@HomeSchoolChannel]

Thanks a Ton.. This solved our biggest Problem

[@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".

[@tagpolice7265]

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

[@user-pp1wm5wl1j]

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

[@mileskirat]

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

[@mahdyislam7178]

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

[@baruvenkatasukumar3939]

This is very useful information

[@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.

[@YuriFey-sw5jx]

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

[@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.

[@arbazbamboowala]

Thanks u saved alot of time of mine thanks alot

[@ShaiVardi]

Thank you for his video!!!!

[@noname5905]

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

[@mckevrock]

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

[@juandavidquiceno8684]

Wow , Thank you sooooooo much.

[@abdullakooheji]

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

[@rehanakhter1975]

Thank You

[@TessHere]

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

[@user-kr3hm5ym6k]

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

[@rahuljadhav4883]

Really thank you soo much

[@GrumpyOldMan9]

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

[@Zaddygains]

Thanks so much!

[@elnelly16]

Thanks

[@parthgupta8364]

Thanks a ton

[@ayanshgaming692]

wow, nice

[@hemanthm9524]

This is mail merge

[@khurramshahzad9359]

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

[@alexnail]

So rude, be respectful