laser check template

[bowanad]

Is it possiable to set up a laser check template in WORD so I can write in
the appropreate info and it will print in the correct areas on the check?

 

[Graham Mayor]

If your printer will handle the physical dimensions of the cheque, then you
can set up a template just like any other document - probably using a
borderless table to accept the data. Unless you make out many cheques, a pen
is much simpler and quicker.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[firstcasualty]

I want to do something similar but in my case all the check data I need
is in an Excel spreadsheet.

Two main stumbling blocks - how do I transfer this Excel data into
matching fields in a Word document (three checks a page), like a mail
merge only with a check template?

And, less importantly, as only the check amount numeric features in the
Excel spreadsheet, is there any way to convert the numeric to the
number in words (with the obligatory "+ (cents)/100) at the end),
either before or after merging?

 

[Graham Mayor]

That would not be 'like' a mail merge - it would *be* a mail merge.
Create your three cheques on the page each with the set of merge fields,
then put a next record field at the start of the second and third copies.
You can use a dollartext switch on the numeric field to get the text - see
also the example at http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>