Printing from an excel spread sheet to form question

[`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

[PY & Associates]

Yes, it can be done

"`AMD tower" <bogus@nowhere.net> wrote in message
news:j8_Yf.7356$aW5.1346@trndny07...
> 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
>
>

[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

"`AMD tower" <bogus@nowhere.net> wrote in message
news:j8_Yf.7356$aW5.1346@trndny07...
> 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
>
>

[`AMD tower]

hey py!

Greay idea. thanks.

mike


"PY & Associates" <pynasocas@yahoo.com.sg> wrote in message
news:Os$6tuSWGHA.2376@TK2MSFTNGP03.phx.gbl...
> 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
>
> "`AMD tower" <bogus@nowhere.net> wrote in message
> news:j8_Yf.7356$aW5.1346@trndny07...
>> 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
>>
>>
>
>