Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
[email protected] firstcasualty@googlemail.com is offline
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.word.tables
Jezebel Jezebel is offline
external usenet poster
 
Posts: 1,384
Default 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   Report Post  
Posted to microsoft.public.word.tables
[email protected] firstcasualty@googlemail.com is offline
external usenet poster
 
Posts: 9
Default Printing checks from Word using data from Excel

Cheers

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Merging Excel data to print checks from Word template [email protected] Microsoft Word Help 1 November 3rd 06 12:28 PM
Detach or change SQL data source for Word template, and other Qs SJMac Mailmerge 6 July 27th 06 10:12 AM
I am having difficulty with deleting headers and footers LHD New Users 5 July 24th 06 01:44 AM
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM


All times are GMT +1. The time now is 08:18 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"