I have a sheet with the following data in it (length could vary depending on the day), but the columns should remain the same.




pic1


I want to be able to merge the data into a word document, where the data is merged and a new document is produced for each "Sub's Name". this list will then tell the substitute teacher which class they will be substituting for during each period of the day.

pic2



If anyone can help me figure out how to do this so each substitute will have a separate print out with all the general info on it I would be very appreciative. If it could be handled completely in Excel that would be the best possible situation for the person doing this, I could create a button to run a macro to do this and it would create the files for printing.

Attached Images

	pic2.png (93.3 KB, 12 views)
	pic1.PNG (24.3 KB, 12 views)