I have an excel file with data records in it. I set a range name to include
all the rows and columns containing data, including the header row.

The mail merge works OK. When I preview the letters, all of the records
show. But, when I print, or select the Edit Each Letter option to create a
file, the last record won't print or be stored in the file. I made sure the
filters are set to "All".

Does anyone know what I'm doing wrong? I even tried setting the table to
include one row past where the data stopped, and that didn't help.

I'm stumped. Any insight would be very helpful. Thanks for your time!

Kathleen

Are you sure that you don't have a Next Record field in there somewhere?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"ksa" wrote in message
...
I have an excel file with data records in it. I set a range name to
include
all the rows and columns containing data, including the header row.

The mail merge works OK. When I preview the letters, all of the records
show. But, when I print, or select the Edit Each Letter option to create
a
file, the last record won't print or be stored in the file. I made sure
the
filters are set to "All".

Does anyone know what I'm doing wrong? I even tried setting the table to
include one row past where the data stopped, and that didn't help.

I'm stumped. Any insight would be very helpful. Thanks for your time!

Kathleen