Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel data to print checks from Word template
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.docmanagement
|
|||
|
|||
Merging Excel data to print checks from Word template
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? This is going to depend on what you mean by "a check template". If you're allowed to make changes to it, you can certainly set it up for mail merge. Connect it to the Excel data source and insert mergefields where the data should go. At the beginning of the second and third checks on the same page, insert a "Next Record" field (from the Word Fields dropdown on the mail merge toolbar). 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? Insert the merge field for the number. Select it and press Shift+F9 to see the field code. At the end of the field code, type in the switch that converts numbers to text: \* DollarText. Shift+F9 again to hide the field codes. Example: { MergeField Amount \* DollarText } Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detach or change SQL data source for Word template, and other Qs | Mailmerge | |||
Yet another letterhead template question | Page Layout | |||
WP merge file to Word | Tables | |||
How Come? | Mailmerge | |||
Why isn't all my Excel data merging into my Word labels document? | Mailmerge |