1. As a workaround, consider opening the data source in Word, using
convert text to table to convert it to a table (if it doesn't have more
than the permitted number of columns in Word), ensure there is a row
with column names at the top, save that as a .doc, and use that as a
datasource.
2. for troubleshooting, I would first look for "oddities" in/around
record 186, such as
- accented/"international" characters
- double quote characters in the data (if there are any, they
typically need to be doubled up)
- other delimiter characters such as commas in the data
Peter Jamieson
http://tips.pjmsn.me.uk
dan wrote:
I've got a line of business application (Dentrix for dental offices)
exporting a set of data for use by Word (in this case word 2007) to create
mailmerge letters. I can look at the exported datafile from within Dentrix
and it shows all the records (about 250 names in this case, last one being a
name starting with Z). When I run the mailmerge to Word 2007, after I've
chosen the recipients and choose to edit recipients, I see there are only
186 records, the last one being a name starting with R. Word doesn't seem to
be acknowledging all the data in the file, which appears to be in CSV
format. The result is repeatable, and also occurs with Word 2003.
Any thoughts on how I can troubleshoot this? Since it's a handoff, I'm
getting a run around from Dentrix support. TIA