last record in mail merge missing

K

ksa

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
 
D

Doug Robbins

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge skipping records/sending one at a time 0
Duplicate Mail Merge Record Every Time 5
Grouping Names in Mail Merge 0
Page numbering with Merged Document and IF statements 1
Mail Merge - displaying a conditional number of decimals 5
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Mail merge labels 8 per page, but 84 is not divisible by 8 3
Mail Merge to form with 3 records per page - Help 1

Top