Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Printing checks from Word using data from Excel
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? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
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? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Printing checks from Word using data from Excel
Cheers
|
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Merging Excel data to print checks from Word template | Microsoft Word Help | |||
Detach or change SQL data source for Word template, and other Qs | Mailmerge | |||
I am having difficulty with deleting headers and footers | New Users | |||
WP merge file to Word | Tables |