Printing checks from Word using data from Excel
Use mailmerge. Word doesn't care what sort of document you're creating. To
display a number in words, use the DollarText formatting switch in the
field.
wrote in message
oups.com...
I want to print checks from Word but 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?
|