Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mail merge drops records at new page
I have a 300-record, 4-field Excel file merging into a Word 2 column by 5 (or
7) label document. It's not really labels but the format is what I need. When the merge moves to a new page, it skips a record in the Excel file. Thus, page one merges records 1-10 (or 1-14) and page two starts with record 12 (or 16). Each page "loses" a record. Any thoughts on why this is and how to fix it? |
#2
|
|||
|
|||
Sounds like you have a Next Record field in the first label where it is
not required. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "lmcwill" wrote in message ... I have a 300-record, 4-field Excel file merging into a Word 2 column by 5 (or 7) label document. It's not really labels but the format is what I need. When the merge moves to a new page, it skips a record in the Excel file. Thus, page one merges records 1-10 (or 1-14) and page two starts with record 12 (or 16). Each page "loses" a record. Any thoughts on why this is and how to fix it? |
#3
|
|||
|
|||
Taking the {Next Record} field out of the first label (at the end of the last
line) results in merging the Excel record twice. And the merge still misses a record at the new page. Thanks, though. "Doug Robbins" wrote: Sounds like you have a Next Record field in the first label where it is not required. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "lmcwill" wrote in message ... I have a 300-record, 4-field Excel file merging into a Word 2 column by 5 (or 7) label document. It's not really labels but the format is what I need. When the merge moves to a new page, it skips a record in the Excel file. Thus, page one merges records 1-10 (or 1-14) and page two starts with record 12 (or 16). Each page "loses" a record. Any thoughts on why this is and how to fix it? |
#4
|
|||
|
|||
Next record field should be at the *start* of each label except the first.
Word puts it there automatically! See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org lmcwill wrote: Taking the {Next Record} field out of the first label (at the end of the last line) results in merging the Excel record twice. And the merge still misses a record at the new page. Thanks, though. "Doug Robbins" wrote: Sounds like you have a Next Record field in the first label where it is not required. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "lmcwill" wrote in message ... I have a 300-record, 4-field Excel file merging into a Word 2 column by 5 (or 7) label document. It's not really labels but the format is what I need. When the merge moves to a new page, it skips a record in the Excel file. Thus, page one merges records 1-10 (or 1-14) and page two starts with record 12 (or 16). Each page "loses" a record. Any thoughts on why this is and how to fix it? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutliple Records for each document in mail merge | Mailmerge | |||
Word datasource sort doesn't sort all records in mail merge | Mailmerge | |||
SAVING MAIL MERGE RECORDS | Mailmerge | |||
mail merge phantom records | Mailmerge | |||
Mail merge drops zip codes and replaces with zero | Mailmerge |