Hi
I have an excel worksbook (MS 2010), with multiply worksheets. Data is hyperlinked to the first Tab which is used as the data source to merge to a Word document using standard MailMerge functions.
I have over 800 columns of data which are all within a defined Name Range.
When I come to "Insert Merge Field" - in Word, it is only recognising the data up to column 187
Various sources tell me there is no limitation other than the number of columns in Excel - 16,000 plus but mine is stopping at this point.
The worksheet is used by other parties to complete data then merge to a Word output document
Using Open Data Source MS Excel worksheets via DDE to link to the workbook if that helps
Appreciate if anyone knows what I'm doing wrong
This has been working fine of over a year when we had data under 187 columns, but now have a need to go larger, it fails to now work as before
Bookmarks