Home |
Search |
Today's Posts |
#1
|
|||
|
|||
last record in mail merge missing
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge - Next Record If Statement | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
How to choose your own record deliminators in mail merge? | Mailmerge | |||
How do I keep a blank line from printing in a mail merge? Record. | Mailmerge | |||
Missing lines in mail merge labels | Mailmerge |