[Graham in Sussex]

I have an Excel file with 75 records but when I try to mail merge it in Word
it cuts off after 70 records. If I sort the fiel so the missing records are
at the beginning it does the same thing - the last 5 records are omitted in
the mail merge. Any idea why please? I'm using Office 2007.
Thank you.

[Peter Jamieson]

Can we assume that you are "completing the merge", e.g. if you happen to be
using a lable layout with 70 labels per page, you will only see the first 70
records until you merge to a new document or to a printer?

Assuming that we can...

When you connect to your data source, you should see a list of "tables."
Usually there will be one table for each sheet in your workbook. But if you
have created a range name that happens to "cover" 70 records, that will be
listed as well: if you sort the records in the /worksheet/, the range name
will still only "cover" the first 70 records.

Well, that doesn't sound too likely either. Other things to look out for are
empty rows and hidden rows (although I would have thought that your "sort"
experiment would have revealed those kinds of problem)

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

"Graham in Sussex" Graham in wrote in
message ...
I have an Excel file with 75 records but when I try to mail merge it in
Word
it cuts off after 70 records. If I sort the fiel so the missing records
are
at the beginning it does the same thing - the last 5 records are omitted
in
the mail merge. Any idea why please? I'm using Office 2007.
Thank you.