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