Mailmerge prints first 2 records then skips two then repeats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

l8tto - 09 Aug 2006 22:45 GMT

I am using mailmerge to print postcards using a mailing list in excel. After
I complete the merge, I print the postcards (4 to a page). What I get
printed are the first two records, then it skips two, then I get the next two
records. So I get records 1,2,5,6 printed on my first page, 9,10,13,14 on
the second page and so on. How do I make it stop skipping records?

Reply to this Message

Peter Jamieson - 09 Aug 2006 23:08 GMT

It sounds as if you have { NEXT } fields (<<Next Record>> fields) in the
wrong places.

There should be one at the beginning of each postcard except the first.

It looks as if there are two at the beginning of postcard "3" and two at the
end of the page.

Peter Jamieson

>I am using mailmerge to print postcards using a mailing list in excel.
>After
[quoted text clipped - 3 lines]
> records. So I get records 1,2,5,6 printed on my first page, 9,10,13,14 on
> the second page and so on. How do I make it stop skipping records?

Reply to this Message

Graham Mayor - 10 Aug 2006 06:33 GMT

If you use a label merge type it is quite difficult to get this wrong - see
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am using mailmerge to print postcards using a mailing list in
> excel. After I complete the merge, I print the postcards (4 to a
> page). What I get printed are the first two records, then it skips
> two, then I get the next two records. So I get records 1,2,5,6
> printed on my first page, 9,10,13,14 on the second page and so on.
> How do I make it stop skipping records?

Reply to this Message