Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using Mail Merge to import Excel data to Word for printing checks
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.mailmerge.fields
|
|||
|
|||
Using Mail Merge to import Excel data to Word for printing checks
You can use mail merge with your check template. Just insert a Next
Record field before the first mergefield in the second and third checks on the page. Adding a \* DollarText switch to a numeric mergefield will give you the dollar amount in words + (cents)/100 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP 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.mailmerge.fields
|
|||
|
|||
Using Mail Merge to import Excel data to Word for printing checks
http://www.gmayor.com/formatting_word_fields.htm shows a method of getting
even tighter control over the reproduction of cash amounts as text. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Doug Robbins - Word MVP wrote: You can use mail merge with your check template. Just insert a Next Record field before the first mergefield in the second and third checks on the page. Adding a \* DollarText switch to a numeric mergefield will give you the dollar amount in words + (cents)/100 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 Mail Merge Problem when E-Mailing Data Source | Mailmerge | |||
Editing Mail Merge Recipients | Mailmerge | |||
Excel data truncated to 255 chars in Word Mail Merge | Mailmerge | |||
Mail Merge of a Date from Excel Data into Microsoft Word | Microsoft Word Help | |||
Insert excel data into word via mail merge | Mailmerge |