mail merge labels prints way too many pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joany - 11 May 2006 20:15 GMT

Hello, I am using Word 2003 and when I do a mail merge for labels I get as
many pages printed as entries in database. Example: I have a database with
124 names in it. When I complete my merge I have 124 pages! I am getting
thirty labels per page but they are just repeats. Any help would be
appreciated. Thank you. Joany

Reply to this Message

Doug Robbins - Word MVP - 11 May 2006 21:16 GMT

You need to have a <<Next Record>> field before the first merge field in
each label in the main document EXCEPT the first one.

I am not sure how you ended up without that field there, but it's probably
best if you take a look at the article "Mailmerge Labels with Word XP" on
fellow MVP Graham Mayor's website at:

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

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

> Hello, I am using Word 2003 and when I do a mail merge for labels I get as
> many pages printed as entries in database. Example: I have a database
[quoted text clipped - 3 lines]
> thirty labels per page but they are just repeats. Any help would be
> appreciated. Thank you. Joany

Reply to this Message

Joany - 12 May 2006 15:06 GMT

Thank you Doug, I will check out his website. I have a next record printed
on all labels except the first one. Regards, Joany

> You need to have a <<Next Record>> field before the first merge field in
> each label in the main document EXCEPT the first one.
[quoted text clipped - 12 lines]
> > thirty labels per page but they are just repeats. Any help would be
> > appreciated. Thank you. Joany

Reply to this Message

Doug Robbins - Word MVP - 12 May 2006 18:35 GMT

When you say printed on the labels, do you mean on the labels as printed.
If that is the case, it is probably not a Next Record field?

In the mail merge main document, if you press Alt+F9, what do you see?

Signature

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

> Thank you Doug, I will check out his website. I have a next record
> printed
[quoted text clipped - 18 lines]
>> > thirty labels per page but they are just repeats. Any help would be
>> > appreciated. Thank you. Joany

Reply to this Message