Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
plm plm is offline
external usenet poster
 
Posts: 1
Default Why is my mail merge skipping every third record?

When I merge an excel database into a name badge template it skips every
third record. I believe I do have "next record" in the correct place. Out
of 362 records only 242 are being merged. I am using Windows XP Professional.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Why is my mail merge skipping every third record?

Where do you have the Next Record fields? There should be one BEFORE
the first merge field on each name badge in the mail merge main document
EXCEPT for the first name badge.

You should NOT have the Next Record field after the merge fields on each
name badge ESPECIALLY after the merge fields on the last name badge on the
mail merge main document as Word indexes automatically when it goes to the
next sheet and if you also have a Next Record field at that point, Word
will index by 2.

--
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

"plm" wrote in message
...
When I merge an excel database into a name badge template it skips every
third record. I believe I do have "next record" in the correct place.
Out
of 362 records only 242 are being merged. I am using Windows XP
Professional.



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
NO CODE - mail merge to Outlook with attachment with CC BrianH Mailmerge 1 February 10th 10 03:53 PM
Help on Mail Merge just only Show One Record Alan Tang Mailmerge 2 February 21st 06 11:57 AM
"Next Record If", Mail Merge Issues [email protected] Mailmerge 8 February 8th 06 08:11 PM
mail merge screws up one record, others okay Mike Mailmerge 1 December 8th 05 07:49 PM
sort mail merge by merge record number nathan Mailmerge 1 August 10th 05 07:09 AM


All times are GMT +1. The time now is 08:59 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"