Mail merge for labels

[STOG]

I'm trying to make mailing labels in Word 2007 from an Excel 2007 database,
but the merge ends at record 249 rather than the actual 700 records. I
haven't had any problem doing this kind of merge before with longer recipient
lists. I've checked the database which looks ok and tried starting over
using mail merge. Any help would be appreciated.

 

[Peter Jamieson]

I do not know what is wrong, but...

As a workaround, you may be able to copy/paste the entire database into
a Word document and use that as the data source.

Are you seeing all 700 records listed in Mail Merge Recipients?

It may be worth re-examining your database looking for hidden (and
empty) rows.

The way Word connects to Excel these days there should not be problems
with "special characters" such as double-quotes, but it may be worth
seeing if there is anything atypical in the data around row 249.

Is your Excel workbook a .doc, docx/.docm? Does it make any difference
if you save in the other format?

Peter Jamieson

http://tips.pjmsn.me.uk

 

[STOG]

I tried saving the database as an xlsx, still didn't recognize anything more
than 249 records, which is the number that shows in "mail merge recipients."
I can't see anything on the database around record 249 that's any different
from the succeeding rows. There are no blank rows (which would have resulted
in blank labels) mail merge simply doesn't see the rest of the database. I
copied the database to a word document but mail merge couldn't use that
format.

 

[Peter Jamieson]

You can also try saving as .csv format and see if that makes any difference.
I think you may lose multiline data, i.e. line breaks may be removed.

So far I have been unable to replicate this, but there might conceivably be
a problem if you have large amounts of data per row - not just a large
number of columns (although if you have more than 255, all bets are off as
the columns beyond 255 can't get through), but lots of data per column.

In any case, do you have more than 63 columns? In that case I think the
edit->copy, edit->paste to Word will concatenate all the data from columns
64 onwards into column 63. Otherwise, it may be significant that the data
will not copy/paste as a Word table is usually a reliable data source.

Peter Jamieson