Merge stops short but w/o errors

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 13 Apr 2006 17:27 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 13 Apr 2006 21:27 GMT

A blank row after record X.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>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
[quoted text clipped - 5 lines]
> I presume there is somethign screwy in the Excel data causing this. What
> should I look for?

Reply to this Message

Cindy M -WordMVP- - 18 Apr 2006 14:37 GMT

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
[quoted text clipped - 3 lines]
> 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 :-)

Reply to this Message