Mail Merge with Labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erika - 04 Dec 2007 21:01 GMT

I am creating mailing labels using a mailmerge - I have 30 labels with that
are all the same and then the next 30 start the next persons name. Is there
a way that I can have word automatically insert a page break when the name
changes?

Reply to this Message

Doug Robbins - Word MVP - 04 Dec 2007 21:20 GMT

Assuming that you have 30 labels on each sheet, remove the Next Record field
from all of the labels on the mail merge main document. When you execute
the merge, it automatically indexes to the next record when moving from one
page to the next so you will then get a sheet of labels for each record in
the data source.

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

>I am creating mailing labels using a mailmerge - I have 30 labels with that
> are all the same and then the next 30 start the next persons name. Is
> there
> a way that I can have word automatically insert a page break when the name
> changes?

Reply to this Message

Erika - 04 Dec 2007 21:42 GMT

This worked beautifully - thank you!

> Assuming that you have 30 labels on each sheet, remove the Next Record field
> from all of the labels on the mail merge main document. When you execute
[quoted text clipped - 7 lines]
> > a way that I can have word automatically insert a page break when the name
> > changes?

Reply to this Message