View Single Post
  #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 Mail Merge with Labels

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" wrote in message
...
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?