Mail merge using Word and Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MinMar - 05 Dec 2007 22:53 GMT

The mail merge document has been created in Word. For some reason it only
pulled 214 records from the Excel database. Thinking it was a problem with
the data, I went in and removed several records. When I tried again, the
merge again stopped at record 214 (even though it was a new name for that
entry.)

I am not detecting any gaps (empty columns or rows) that would make the
merge think it had reached the end of the data. Any other factors that could
fool the program in that way?

Your help is appreciated!

M~

Reply to this Message

Peter Jamieson - 06 Dec 2007 15:21 GMT

Which version of Word/Excel?

Any sorts/filters applied?

Any hidden rows? (It doesn't sound like it)

Any double-quote characters in the row immediately before?

Try changing the way that Word connects to the data source (depends on the
version, but in Word 2002/2003 check Word Tools|Options General|COnfirm
conversions at open, go through the connection process again. The options
are DDE (requires Excel and only "sees" the first sheet in the workbook),
the default in Word 2000, ODBC, and OLE DB (the default in Word 2002
onwards, and not available before that). You may also see a "via Converter"
option.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> The mail merge document has been created in Word. For some reason it only
> pulled 214 records from the Excel database. Thinking it was a problem
[quoted text clipped - 11 lines]
>
> M~

Reply to this Message

Islandtop - 07 Dec 2007 18:30 GMT

I think you should also consider whether you have a range set in your Excel
file which the mail merge is using and therefore restricting your data to 214
records.

If you are in Word 2003 or 3 definitely do the Tools:options:General:confirm
that Peter mentions so that you can see what you want. I recommend the DDE
option especially if you are using numbers.

Islandtop

> The mail merge document has been created in Word. For some reason it only
> pulled 214 records from the Excel database. Thinking it was a problem with
[quoted text clipped - 9 lines]
>
> M~

Reply to this Message