Mail Merge with Labels

[Erika]

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?

 

[Doug Robbins - Word MVP]

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.

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

 

[Erika]

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

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