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" wrote:
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 wrote:
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.