Anybody????? I really need help with this.

"Bubba Gump" wrote in message
...
ok, my title may not be accurate but I wasn't quite sure what else to call
it. I have a workbook created that is a page layout of a bunch of
different fields in various locations that will print on a single sheet of
paper. I work in a campus records department and this sheet (we'll call it
workbook1) will be used for our counselors to manually type student data
into the blank provided beside the field label. I have another excel file
(we'll call it workbook2) that actually has the data in it that the
counselors need on workbook1. Workbook2 will include anywhere from 50-300
student records that are about 50 fields of data each. Now I know how to
doa fields reference in workbook1to tell it to grab data from a certain
field in workbook2 (=[workbook2.xls]sheet1!A1). However, is there a way to
do a mail merge of sorts so that it would do this for each and every
record in workbook2 so that if workbook2 has 50 records, it provides 50
page with unique data to that record?

Thanks!
Buster