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

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

Jason
A macro like that below would do what you want. The A1, B1, C1 are the
destination cells in the form and the form is on a second sheet named
"TheForm". The active sheet has the data in columns A:C starting in row 2.
Change these as needed. Post back if you need more. HTH Otto
Sub PrintAll()
Dim rColA As Range
Dim i As Range
Set rColA = Range("A2", Range("A" & Rows.Count).End(xlUp))
With Sheets("TheForm")
For Each i In rColA
.Range("A1") = i
.Range("B1") = i.Offset(, 1)
.Range("C1") = i.Offset(, 2)
Range("WhatToPrint").PrintOut
Next i
End With
End Sub

"Jason K" wrote in message
...
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....

Check your earlier post.

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

--

Dave Peterson