and the Question is in the Subject statement. �s there a word template or
excel template for writing checks on preprinted bank checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing about 1200
checks each with the same date and amount. We have each of the reciepants
names and addresses in an excel spreadsheet and would like to print the
checks by computer on computer checks ordered from our bank and supplied
by
Davis and Henderson a leading check printer in Canada. We would need to
print
on the check is specific locations the date, amount and persons name and
address. This needs to be exact so that the return address on the check
and
the persons name and address printed on the check would show through
standard
windowed envelopes. We intend to use checks that are 3 parts (part 1
check,
part 2 stub and part 3 stub) on each single sheet of check stock. Our
intent
is to also print a standard note on the part 2 and part 3 stub. We do not
have a need to print any deductions etc. on the stub

You mean apart from the one provided by Davis and Henderson?




"F6070" wrote in message
...
and the Question is in the Subject statement. Ïs there a word template or
excel template for writing checks on preprinted bank checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing about
1200
checks each with the same date and amount. We have each of the
reciepants
names and addresses in an excel spreadsheet and would like to print the
checks by computer on computer checks ordered from our bank and
supplied
by
Davis and Henderson a leading check printer in Canada. We would need to
print
on the check is specific locations the date, amount and persons name
and
address. This needs to be exact so that the return address on the check
and
the persons name and address printed on the check would show through
standard
windowed envelopes. We intend to use checks that are 3 parts (part 1
check,
part 2 stub and part 3 stub) on each single sheet of check stock. Our
intent
is to also print a standard note on the part 2 and part 3 stub. We do
not
have a need to print any deductions etc. on the stub

Davis and Henderson only print the actual blank check not the actual date,
person receiveing the check and their address, text amount, numerical amount
nor the signatures. What I'm looking for is a template to use their blank
checks and merge with an excel spreadsheet to print all the needed fields
including is possible jpg images of the signatures. Also I would like to
print a note/letter on the second and 3rd portions/stubs of the checks. The
checks are a sheet with the check on the top portion then under the check the
next 3.5 inches is a blank section where you could print the deductions if
needed we want to insert a note in this sectioin explaining the reson the
check is being sent. The 3rd section another 3.5 inches of stub would also be
used for notes or the remainder of the note contained in the second protion.
e.g. 1 portion 3.5 inches is the blank acatual check with all the preprinted
and encoded standard check stuff. 2nd and 3rd section is blank and we would
use to print a standard note to all those receiveing the check.
"Jezebel" wrote:

You mean apart from the one provided by Davis and Henderson?




"F6070" wrote in message
...
and the Question is in the Subject statement. �s there a word template or
excel template for writing checks on preprinted bank checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing about
1200
checks each with the same date and amount. We have each of the
reciepants
names and addresses in an excel spreadsheet and would like to print the
checks by computer on computer checks ordered from our bank and
supplied
by
Davis and Henderson a leading check printer in Canada. We would need to
print
on the check is specific locations the date, amount and persons name
and
address. This needs to be exact so that the return address on the check
and
the persons name and address printed on the check would show through
standard
windowed envelopes. We intend to use checks that are 3 parts (part 1
check,
part 2 stub and part 3 stub) on each single sheet of check stock. Our
intent
is to also print a standard note on the part 2 and part 3 stub. We do
not
have a need to print any deductions etc. on the stub

Yes I understand what template means. And so, presumably, do Davis and
Henderson, since they provide one for printing their checks.


"F6070" wrote in message
...
Davis and Henderson only print the actual blank check not the actual date,
person receiveing the check and their address, text amount, numerical
amount
nor the signatures. What I'm looking for is a template to use their blank
checks and merge with an excel spreadsheet to print all the needed fields
including is possible jpg images of the signatures. Also I would like to
print a note/letter on the second and 3rd portions/stubs of the checks.
The
checks are a sheet with the check on the top portion then under the check
the
next 3.5 inches is a blank section where you could print the deductions if
needed we want to insert a note in this sectioin explaining the reson the
check is being sent. The 3rd section another 3.5 inches of stub would also
be
used for notes or the remainder of the note contained in the second
protion.
e.g. 1 portion 3.5 inches is the blank acatual check with all the
preprinted
and encoded standard check stuff. 2nd and 3rd section is blank and we
would
use to print a standard note to all those receiveing the check.
"Jezebel" wrote:

You mean apart from the one provided by Davis and Henderson?




"F6070" wrote in message
...
and the Question is in the Subject statement. Ïs there a word template
or
excel template for writing checks on preprinted bank checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing about
1200
checks each with the same date and amount. We have each of the
reciepants
names and addresses in an excel spreadsheet and would like to print
the
checks by computer on computer checks ordered from our bank and
supplied
by
Davis and Henderson a leading check printer in Canada. We would need
to
print
on the check is specific locations the date, amount and persons name
and
address. This needs to be exact so that the return address on the
check
and
the persons name and address printed on the check would show through
standard
windowed envelopes. We intend to use checks that are 3 parts (part 1
check,
part 2 stub and part 3 stub) on each single sheet of check stock.
Our
intent
is to also print a standard note on the part 2 and part 3 stub. We
do
not
have a need to print any deductions etc. on the stub

Daaaaaaaaaaaaaa! what part of they (davis + Henderson) do NOT provide a
template are you not understanding? That is exactly why I'm looking for a
template. Do you have a personal checking account. Look at your unused
checks. That is what Davis and Henderson do. They provide the personalized
blank checks you get for your bank account. They come with your name and
adddress on them and the bank account encoding accross the bottom. You
personally hand write into fields on the check the date, pay to..... the
amount etc and sign the check making it now a form of payment. We're looking
to put the purchased check stock (unused checks) into our printer and using a
word template and a merge function to print on this stock the fields that you
would normally hand write. Yes I would have thought Davis + Henderson might
think it a good sales tool to provide such a template However they do not.

"Jezebel" wrote:

Yes I understand what template means. And so, presumably, do Davis and
Henderson, since they provide one for printing their checks.


"F6070" wrote in message
...
Davis and Henderson only print the actual blank check not the actual date,
person receiveing the check and their address, text amount, numerical
amount
nor the signatures. What I'm looking for is a template to use their blank
checks and merge with an excel spreadsheet to print all the needed fields
including is possible jpg images of the signatures. Also I would like to
print a note/letter on the second and 3rd portions/stubs of the checks.
The
checks are a sheet with the check on the top portion then under the check
the
next 3.5 inches is a blank section where you could print the deductions if
needed we want to insert a note in this sectioin explaining the reson the
check is being sent. The 3rd section another 3.5 inches of stub would also
be
used for notes or the remainder of the note contained in the second
protion.
e.g. 1 portion 3.5 inches is the blank acatual check with all the
preprinted
and encoded standard check stuff. 2nd and 3rd section is blank and we
would
use to print a standard note to all those receiveing the check.
"Jezebel" wrote:

You mean apart from the one provided by Davis and Henderson?




"F6070" wrote in message
...
and the Question is in the Subject statement. �s there a word template
or
excel template for writing checks on preprinted bank checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing about
1200
checks each with the same date and amount. We have each of the
reciepants
names and addresses in an excel spreadsheet and would like to print
the
checks by computer on computer checks ordered from our bank and
supplied
by
Davis and Henderson a leading check printer in Canada. We would need
to
print
on the check is specific locations the date, amount and persons name
and
address. This needs to be exact so that the return address on the
check
and
the persons name and address printed on the check would show through
standard
windowed envelopes. We intend to use checks that are 3 parts (part 1
check,
part 2 stub and part 3 stub) on each single sheet of check stock.
Our
intent
is to also print a standard note on the part 2 and part 3 stub. We
do
not
have a need to print any deductions etc. on the stub

Sheesh. Go and have another look at their website!



"F6070" wrote in message
...
Daaaaaaaaaaaaaa! what part of they (davis + Henderson) do NOT provide a
template are you not understanding? That is exactly why I'm looking for a
template. Do you have a personal checking account. Look at your unused
checks. That is what Davis and Henderson do. They provide the personalized
blank checks you get for your bank account. They come with your name and
adddress on them and the bank account encoding accross the bottom. You
personally hand write into fields on the check the date, pay to..... the
amount etc and sign the check making it now a form of payment. We're
looking
to put the purchased check stock (unused checks) into our printer and
using a
word template and a merge function to print on this stock the fields that
you
would normally hand write. Yes I would have thought Davis + Henderson
might
think it a good sales tool to provide such a template However they do not.

"Jezebel" wrote:

Yes I understand what template means. And so, presumably, do Davis and
Henderson, since they provide one for printing their checks.


"F6070" wrote in message
...
Davis and Henderson only print the actual blank check not the actual
date,
person receiveing the check and their address, text amount, numerical
amount
nor the signatures. What I'm looking for is a template to use their
blank
checks and merge with an excel spreadsheet to print all the needed
fields
including is possible jpg images of the signatures. Also I would like
to
print a note/letter on the second and 3rd portions/stubs of the checks.
The
checks are a sheet with the check on the top portion then under the
check
the
next 3.5 inches is a blank section where you could print the deductions
if
needed we want to insert a note in this sectioin explaining the reson
the
check is being sent. The 3rd section another 3.5 inches of stub would
also
be
used for notes or the remainder of the note contained in the second
protion.
e.g. 1 portion 3.5 inches is the blank acatual check with all the
preprinted
and encoded standard check stuff. 2nd and 3rd section is blank and we
would
use to print a standard note to all those receiveing the check.
"Jezebel" wrote:

You mean apart from the one provided by Davis and Henderson?




"F6070" wrote in message
...
and the Question is in the Subject statement. Ïs there a word
template
or
excel template for writing checks on preprinted bank checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing
about
1200
checks each with the same date and amount. We have each of the
reciepants
names and addresses in an excel spreadsheet and would like to
print
the
checks by computer on computer checks ordered from our bank and
supplied
by
Davis and Henderson a leading check printer in Canada. We would
need
to
print
on the check is specific locations the date, amount and persons
name
and
address. This needs to be exact so that the return address on the
check
and
the persons name and address printed on the check would show
through
standard
windowed envelopes. We intend to use checks that are 3 parts
(part 1
check,
part 2 stub and part 3 stub) on each single sheet of check stock.
Our
intent
is to also print a standard note on the part 2 and part 3 stub.
We
do
not
have a need to print any deductions etc. on the stub

I looked at their Web site (even that is quite difficult to find) and didn't
find any templates. Can you supply a link?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Jezebel" wrote in message
...
Sheesh. Go and have another look at their website!



"F6070" wrote in message
...
Daaaaaaaaaaaaaa! what part of they (davis + Henderson) do NOT provide a
template are you not understanding? That is exactly why I'm looking for
a
template. Do you have a personal checking account. Look at your unused
checks. That is what Davis and Henderson do. They provide the
personalized
blank checks you get for your bank account. They come with your name and
adddress on them and the bank account encoding accross the bottom. You
personally hand write into fields on the check the date, pay to..... the
amount etc and sign the check making it now a form of payment. We're
looking
to put the purchased check stock (unused checks) into our printer and
using a
word template and a merge function to print on this stock the fields
that
you
would normally hand write. Yes I would have thought Davis + Henderson
might
think it a good sales tool to provide such a template However they do
not.

"Jezebel" wrote:

Yes I understand what template means. And so, presumably, do Davis and
Henderson, since they provide one for printing their checks.


"F6070" wrote in message
...
Davis and Henderson only print the actual blank check not the actual
date,
person receiveing the check and their address, text amount, numerical
amount
nor the signatures. What I'm looking for is a template to use their
blank
checks and merge with an excel spreadsheet to print all the needed
fields
including is possible jpg images of the signatures. Also I would like
to
print a note/letter on the second and 3rd portions/stubs of the
checks.
The
checks are a sheet with the check on the top portion then under the
check
the
next 3.5 inches is a blank section where you could print the
deductions
if
needed we want to insert a note in this sectioin explaining the reson
the
check is being sent. The 3rd section another 3.5 inches of stub would
also
be
used for notes or the remainder of the note contained in the second
protion.
e.g. 1 portion 3.5 inches is the blank acatual check with all the
preprinted
and encoded standard check stuff. 2nd and 3rd section is blank and we
would
use to print a standard note to all those receiveing the check.
"Jezebel" wrote:

You mean apart from the one provided by Davis and Henderson?




"F6070" wrote in message
...
and the Question is in the Subject statement. Ïs there a word
template
or
excel template for writing checks on preprinted bank checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing
about
1200
checks each with the same date and amount. We have each of the
reciepants
names and addresses in an excel spreadsheet and would like to
print
the
checks by computer on computer checks ordered from our bank and
supplied
by
Davis and Henderson a leading check printer in Canada. We would
need
to
print
on the check is specific locations the date, amount and persons
name
and
address. This needs to be exact so that the return address on
the
check
and
the persons name and address printed on the check would show
through
standard
windowed envelopes. We intend to use checks that are 3 parts
(part 1
check,
part 2 stub and part 3 stub) on each single sheet of check
stock.
Our
intent
is to also print a standard note on the part 2 and part 3 stub.
We
do
not
have a need to print any deductions etc. on the stub

If Davis & Henderson won't supply a template in Word format then you are
going to have to create your own as all bank cheques have slightly different
layouts. It's essentially a label mail merge, using a table to match the
layout of your cheques.
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm may help.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



F6070 wrote:
Davis and Henderson only print the actual blank check not the actual
date, person receiveing the check and their address, text amount,
numerical amount nor the signatures. What I'm looking for is a
template to use their blank checks and merge with an excel
spreadsheet to print all the needed fields including is possible jpg
images of the signatures. Also I would like to print a note/letter on
the second and 3rd portions/stubs of the checks. The checks are a
sheet with the check on the top portion then under the check the next
3.5 inches is a blank section where you could print the deductions if
needed we want to insert a note in this sectioin explaining the reson
the check is being sent. The 3rd section another 3.5 inches of stub
would also be used for notes or the remainder of the note contained
in the second protion. e.g. 1 portion 3.5 inches is the blank acatual
check with all the preprinted and encoded standard check stuff. 2nd
and 3rd section is blank and we would use to print a standard note to
all those receiveing the check. "Jezebel" wrote:

You mean apart from the one provided by Davis and Henderson?




"F6070" wrote in message
...
and the Question is in the Subject statement. Ïs there a word
template or excel template for writing checks on preprinted bank
checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing
about 1200
checks each with the same date and amount. We have each of the
reciepants
names and addresses in an excel spreadsheet and would like to
print the checks by computer on computer checks ordered from our
bank and supplied
by
Davis and Henderson a leading check printer in Canada. We would
need to print
on the check is specific locations the date, amount and persons
name and
address. This needs to be exact so that the return address on the
check and
the persons name and address printed on the check would show
through standard
windowed envelopes. We intend to use checks that are 3 parts
(part 1 check,
part 2 stub and part 3 stub) on each single sheet of check stock.
Our intent
is to also print a standard note on the part 2 and part 3 stub.
We do not
have a need to print any deductions etc. on the stub

Thanks, I see that you understand the problem. having to set up our own
label mail merge is our last resort as you are correct checks differ in
layout. So to do this we need first to order the stock at a cost of $600.00
only then can we get the correct positioning of the fields. I was hoping
since Davis + Henderson are the leading Check supplier in Canada that there
would already be templates/label mail merge setups out there somewhere for
their products.

"Graham Mayor" wrote:

If Davis & Henderson won't supply a template in Word format then you are
going to have to create your own as all bank cheques have slightly different
layouts. It's essentially a label mail merge, using a table to match the
layout of your cheques.
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm may help.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



F6070 wrote:
Davis and Henderson only print the actual blank check not the actual
date, person receiveing the check and their address, text amount,
numerical amount nor the signatures. What I'm looking for is a
template to use their blank checks and merge with an excel
spreadsheet to print all the needed fields including is possible jpg
images of the signatures. Also I would like to print a note/letter on
the second and 3rd portions/stubs of the checks. The checks are a
sheet with the check on the top portion then under the check the next
3.5 inches is a blank section where you could print the deductions if
needed we want to insert a note in this sectioin explaining the reson
the check is being sent. The 3rd section another 3.5 inches of stub
would also be used for notes or the remainder of the note contained
in the second protion. e.g. 1 portion 3.5 inches is the blank acatual
check with all the preprinted and encoded standard check stuff. 2nd
and 3rd section is blank and we would use to print a standard note to
all those receiveing the check. "Jezebel" wrote:

You mean apart from the one provided by Davis and Henderson?




"F6070" wrote in message
...
and the Question is in the Subject statement. �s there a word
template or excel template for writing checks on preprinted bank
checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing
about 1200
checks each with the same date and amount. We have each of the
reciepants
names and addresses in an excel spreadsheet and would like to
print the checks by computer on computer checks ordered from our
bank and supplied
by
Davis and Henderson a leading check printer in Canada. We would
need to print
on the check is specific locations the date, amount and persons
name and
address. This needs to be exact so that the return address on the
check and
the persons name and address printed on the check would show
through standard
windowed envelopes. We intend to use checks that are 3 parts
(part 1 check,
part 2 stub and part 3 stub) on each single sheet of check stock.
Our intent
is to also print a standard note on the part 2 and part 3 stub.
We do not
have a need to print any deductions etc. on the stub

If they are the leading supplier - ask them for a sample. They must have
come across this issue before.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


F6070 wrote:
Thanks, I see that you understand the problem. having to set up our
own label mail merge is our last resort as you are correct checks
differ in layout. So to do this we need first to order the stock at a
cost of $600.00 only then can we get the correct positioning of the
fields. I was hoping since Davis + Henderson are the leading Check
supplier in Canada that there would already be templates/label mail
merge setups out there somewhere for their products.

"Graham Mayor" wrote:

If Davis & Henderson won't supply a template in Word format then you
are going to have to create your own as all bank cheques have
slightly different layouts. It's essentially a label mail merge,
using a table to match the layout of your cheques.
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm may help.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



F6070 wrote:
Davis and Henderson only print the actual blank check not the actual
date, person receiveing the check and their address, text amount,
numerical amount nor the signatures. What I'm looking for is a
template to use their blank checks and merge with an excel
spreadsheet to print all the needed fields including is possible jpg
images of the signatures. Also I would like to print a note/letter
on the second and 3rd portions/stubs of the checks. The checks are a
sheet with the check on the top portion then under the check the
next
3.5 inches is a blank section where you could print the deductions
if needed we want to insert a note in this sectioin explaining the
reson the check is being sent. The 3rd section another 3.5 inches
of stub would also be used for notes or the remainder of the note
contained in the second protion. e.g. 1 portion 3.5 inches is the
blank acatual check with all the preprinted and encoded standard
check stuff. 2nd and 3rd section is blank and we would use to print
a standard note to all those receiveing the check. "Jezebel" wrote:

You mean apart from the one provided by Davis and Henderson?




"F6070" wrote in message
...
and the Question is in the Subject statement. Ïs there a word
template or excel template for writing checks on preprinted bank
checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing
about 1200
checks each with the same date and amount. We have each of the
reciepants
names and addresses in an excel spreadsheet and would like to
print the checks by computer on computer checks ordered from our
bank and supplied
by
Davis and Henderson a leading check printer in Canada. We would
need to print
on the check is specific locations the date, amount and persons
name and
address. This needs to be exact so that the return address on
the check and
the persons name and address printed on the check would show
through standard
windowed envelopes. We intend to use checks that are 3 parts
(part 1 check,
part 2 stub and part 3 stub) on each single sheet of check
stock. Our intent
is to also print a standard note on the part 2 and part 3 stub.
We do not
have a need to print any deductions etc. on the stub

I had the same question and found your post. I had to create a word merge
document that is laid out like the check and a data table that holds the info
to merge onto the "voucher Style" check. It may take some time to get the
fields to line up right on your preprinted check so you could make some
photocopies of your check and practice. Determine which side and direction
your printer prints on and then just feed your checks into the printer and
wala...
You have to start with a "letter" but change the merge field names to the
fields on your check. I have a sample I could e-mail to you but your address
is not available here. Good Luck

"F6070" wrote:

Davis and Henderson only print the actual blank check not the actual date,
person receiveing the check and their address, text amount, numerical amount
nor the signatures. What I'm looking for is a template to use their blank
checks and merge with an excel spreadsheet to print all the needed fields
including is possible jpg images of the signatures. Also I would like to
print a note/letter on the second and 3rd portions/stubs of the checks. The
checks are a sheet with the check on the top portion then under the check the
next 3.5 inches is a blank section where you could print the deductions if
needed we want to insert a note in this sectioin explaining the reson the
check is being sent. The 3rd section another 3.5 inches of stub would also be
used for notes or the remainder of the note contained in the second protion.
e.g. 1 portion 3.5 inches is the blank acatual check with all the preprinted
and encoded standard check stuff. 2nd and 3rd section is blank and we would
use to print a standard note to all those receiveing the check.
"Jezebel" wrote:

You mean apart from the one provided by Davis and Henderson?




"F6070" wrote in message
...
and the Question is in the Subject statement. �s there a word template or
excel template for writing checks on preprinted bank checks?

"Jezebel" wrote:

And the question is...?



"F6070" wrote in message
...
I am working with a group that has a one time task of issueing about
1200
checks each with the same date and amount. We have each of the
reciepants
names and addresses in an excel spreadsheet and would like to print the
checks by computer on computer checks ordered from our bank and
supplied
by
Davis and Henderson a leading check printer in Canada. We would need to
print
on the check is specific locations the date, amount and persons name
and
address. This needs to be exact so that the return address on the check
and
the persons name and address printed on the check would show through
standard
windowed envelopes. We intend to use checks that are 3 parts (part 1
check,
part 2 stub and part 3 stub) on each single sheet of check stock. Our
intent
is to also print a standard note on the part 2 and part 3 stub. We do
not
have a need to print any deductions etc. on the stub