![]() |
|
|
|
#1
|
||||
|
||||
|
Ordinarily, this kind of thing would be done with a mailmerge, using Word to extract the Excel data. In such a scenario, the text output is as simple as adding a CardText field switch to the relevant MERGEFIELD.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
#2
|
||||
|
||||
|
Thank you for the quick reply macropod. Actually mail merge is being used in the preparation of the certificates with excel table as its source, but the excel data is in years 1900 to 2019. Typing the years in words is prone to errors so I am hoping that there's a code to automatically convert the numbers into words.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Use macro on form activate attached to read only file
|
smarti | Word VBA | 3 | 03-02-2017 09:06 AM |
Macro to read cell contents and compare data
|
jrfoley3 | Excel Programming | 7 | 07-09-2016 12:25 PM |
Macro will not read the value of cell with a formula in it!
|
grayson1231 | Excel Programming | 10 | 03-28-2015 03:47 PM |
| Email macro to read range for .To field | MattMurdock | Excel Programming | 2 | 08-07-2012 06:46 AM |
Macro to read word document
|
harishankar.selvaraju | Excel Programming | 1 | 06-14-2012 03:48 AM |