Reply
 
Thread Tools Display Modes
  #1   Report Post  
Doug Robbins
 
Posts: n/a
Default

Remove the Next Record field from the first label in the mailmerge main
document.

--
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
"Donna" wrote in message
...
I'm merging records from Excel into a Word template. The template is a
modified label format that prints 10 cards per page. During merging,
every
eleventh record throughout the entire database has been skipped.

I use the same data to merge with an Address Label Template #5660 - No
records are skipped.



  #2   Report Post  
Donna
 
Posts: n/a
Default

Not working. When I remove Next Record, it prints that first record
twice. Now, instead of skipping every eleventh record, it skips every tenth.

"Doug Robbins" wrote:

Remove the Next Record field from the first label in the mailmerge main
document.

--
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
"Donna" wrote in message
...
I'm merging records from Excel into a Word template. The template is a
modified label format that prints 10 cards per page. During merging,
every
eleventh record throughout the entire database has been skipped.

I use the same data to merge with an Address Label Template #5660 - No
records are skipped.




  #3   Report Post  
Graham Mayor
 
Posts: n/a
Default

See where what you are doing differs from
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


Donna wrote:
Not working. When I remove Next Record, it prints that first
record twice. Now, instead of skipping every eleventh record, it
skips every tenth.

"Doug Robbins" wrote:

Remove the Next Record field from the first label in the
mailmerge main document.

--
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
"Donna" wrote in message
...
I'm merging records from Excel into a Word template. The template
is a modified label format that prints 10 cards per page. During
merging, every
eleventh record throughout the entire database has been skipped.

I use the same data to merge with an Address Label Template #5660 -
No records are skipped.



  #4   Report Post  
Doug Robbins
 
Posts: n/a
Default

The Next Record field must be the first field in all of the labels except
for the first label on the sheet in which there must not be a Next Record
field.

If after removing the Next Record field from the first label, that record
prints twice, it indicates to me that you have the Next Record field AFTER
the other merge fields in the labels, NOT BEFORE them.

--
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
"Donna" wrote in message
...
Not working. When I remove Next Record, it prints that first record
twice. Now, instead of skipping every eleventh record, it skips every
tenth.

"Doug Robbins" wrote:

Remove the Next Record field from the first label in the mailmerge
main
document.

--
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
"Donna" wrote in message
...
I'm merging records from Excel into a Word template. The template is a
modified label format that prints 10 cards per page. During merging,
every
eleventh record throughout the entire database has been skipped.

I use the same data to merge with an Address Label Template #5660 - No
records are skipped.






  #5   Report Post  
Donna
 
Posts: n/a
Default

Doug, I knew I was doing something wrong. This WORKED. THANKS.

"Doug Robbins" wrote:

The Next Record field must be the first field in all of the labels except
for the first label on the sheet in which there must not be a Next Record
field.

If after removing the Next Record field from the first label, that record
prints twice, it indicates to me that you have the Next Record field AFTER
the other merge fields in the labels, NOT BEFORE them.

--
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
"Donna" wrote in message
...
Not working. When I remove Next Record, it prints that first record
twice. Now, instead of skipping every eleventh record, it skips every
tenth.

"Doug Robbins" wrote:

Remove the Next Record field from the first label in the mailmerge
main
document.

--
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
"Donna" wrote in message
...
I'm merging records from Excel into a Word template. The template is a
modified label format that prints 10 cards per page. During merging,
every
eleventh record throughout the entire database has been skipped.

I use the same data to merge with an Address Label Template #5660 - No
records are skipped.








Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why is my merge skipping records? xlntgaltw68 Mailmerge 9 July 14th 05 06:31 PM
skipped mail merge records cls Mailmerge 1 April 28th 05 05:54 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
mail merge phantom records Believr Mailmerge 1 April 6th 05 06:50 PM
How to Mail merge records into a new/separate document Denise Mailmerge 1 February 1st 05 11:25 PM


All times are GMT +1. The time now is 06:16 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"