Hi, I'd like to create a form which includes a "Order Number", so if I
print 500 copies and my first page number is say 300, my first copy will be
300, the next copy would be 301 and so on..... I've tried different functions
in the header/footer... and cant get anything to work....

how about "printing 500 times" rather then "printing 500 copies"...

i don't know if there is any function for header/footer to do this but you
can use VBA to increment your "Order Number". Is your "Order Number" means
like page numbering or what?

"brian" wrote:

Hi, I'd like to create a form which includes a "Order Number", so if I
print 500 copies and my first page number is say 300, my first copy will be
300, the next copy would be 301 and so on..... I've tried different functions
in the header/footer... and cant get anything to work....

Hi, I'd like to create a form which includes a "Order Number", so if
I print 500 copies and my first page number is say 300, my first copy
will be 300, the next copy would be 301 and so on..... I've tried
different functions in the header/footer... and cant get anything to
work....

I use a Windows program, FinePrint:
http://fineprint.com/products/fineprint/index.html
One of its features -- "stationery" -- does what you want.

FinePrint installs like a printer driver, so it works with any application,
not just Excel.