printing checks

  • Thread starter esslingerdav \(removethis\)
  • Start date
E

esslingerdav \(removethis\)

I need to find out if there is any way to print checks
with mail merge. I have the name and amount (ex: Susie
Smith / $5.00) in an excell worksheet. I need to find out:
1. is there a way to merge or convert the dollar figure
to dollar text (ex: five dollars)and ..
2. are there any check templates available like there are
label templates?

thanks!
 
F

Frank Kabel

Hi
For the first question:
Try doing a Google search and you'll find many macros/procedures to
convert numbers to text. Below a short list for this topic:
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional concatenating!!! 3
State Tax Business Calculations Help 1
Page numbering with Merged Document and IF statements 1
printing checks 1
Rounding dollar amounts to the 9 cents 0
Mail Merge - displaying a conditional number of decimals 5
Trying to create custom labels from an csv file + Need items numerically counted out 0
is there a way to type a number and have it translated into text? 1

Top