This would best be done in Word with Excel as the source for a mailmerge.

Your form being the document in Word to merge to.

But you can do it in Excel alone.

John Walkenbach has a sample workbook on his site.

http://spreadsheetpage.com/index.php..._without_word/


Gord Dibben MS Excel MVP

On Thu, 7 Jan 2010 13:53:01 -0800, Jason K
wrote:

I have a pre-made check request form. I need to print a form with certain
data on each. such as name, agent number, and amount. I have a couple hundred
of them to print (one ck request for each person). is there a way to print
the forms and auto enter the name, agent number, and amount on each form?

Thank You....