Printing from an excel spread sheet to form question

A

`AMD tower

Hi,

A friend picked up a ton of contiuous paper, 3 part,
at a very good price, and wants to use it for billing.
The paper alreadys has a form on it with a place for address, and the usual
billing fields, amt, quantity, price per unit, date, etc.

If we make a big spreadsheet, big to us would be about 1000 customers,
is it possible to use that sheet, as a database, from which to draw the
information from and then print on the pre-formated form feed paper into
the right places?

I know access can do this, but nobody in the office knows how to
run access, and nobody wants to learn how either.

The secretaries could enter the non-recurring data, amt, etc.

He has a 9 pin epson impact printer that will handle the paper.

Thanks,

Mike
 
P

PY & Associates

Start by printing a dummy sheet with row 1 = "a", "b", ... say "t"
put 2, 3, ... 64 down column A
turn grid on
use the impact printer

now you know where to put the relevant information.
the rest is your creation please
 
A

`AMD tower

hey py!

Greay idea. thanks.

mike


PY & Associates said:
Start by printing a dummy sheet with row 1 = "a", "b", ... say "t"
put 2, 3, ... 64 down column A
turn grid on
use the impact printer

now you know where to put the relevant information.
the rest is your creation please
Click to expand...
 
Top