Hi =?Utf-8?B?TWlrZQ==?=,
I am merging data from Excel into a Word document to create a catalog. The
merge chugs along fine but stops before all the data in the spreadsheet range
has been used. No error messages... it just finishes with record "X". The
same record each time.
I presume there is somethign screwy in the Excel data causing this. What
should I look for?
<bemused>There is a mail merge newsgroup (word.mailmerge.fields); you might have
gotten a more thorough answer, more quickly, there than in a group unrelated to
your question (vba has to do with writing macro code).
For mail merge questions it's important that you mention the version of Word
and, if you know it, the type of data link the mail merge is using.
If Doug's answer wasn't on target, then the problem could be either a damaged
Excel file or a damaged Word document. To test this, try merging to the same
data source with a new document. If that brings across all the records, the
problem is with the Word file. If it stops in the same place, the problem is
with the Excel file. Once you've narrowed that down, how to solve the problem
can be discussed.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail
