 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2006Using 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? 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  SignatureHope 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 >I want to print checks from Word but all the check data I need > is in an Excel spreadsheet. [quoted text clipped - 8 lines] > number in words (with the obligatory "+ (cents)/100) at the end), > either before or after merging? http://www.gmayor.com/formatting_word_fields.htm shows a method of getting even tighter control over the reproduction of cash amounts as text. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > You can use mail merge with your check template. Just insert a <<Next > Record>> field before the first mergefield in the second and third [quoted text clipped - 14 lines] >> number in words (with the obligatory "+ (cents)/100) at the end), >> either before or after merging? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.