Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Erika Erika is offline
external usenet poster
 
Posts: 83
Default Mail Merge with Labels

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



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Erika Erika is offline
external usenet poster
 
Posts: 83
Default Mail Merge with Labels

This worked beautifully - thank you!

"Doug Robbins - Word MVP" wrote:

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?




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge to continuous labels skips labels between pages Devon Stout Mailmerge 8 July 10th 06 07:11 PM
Mail Merge - How do I set-up Home Phone & e-mail lines on labels? Eve Mailmerge 1 May 17th 06 08:54 PM
Mail merge labels will not fully merge Kathie Mailmerge 2 November 21st 05 11:02 PM
How do I e-mail mail-merge made labels? ParrotBayFun Mailmerge 2 June 26th 05 06:01 AM
Word Labels into Mail Merge Labels GG Katie Mailmerge 1 January 24th 05 11:12 PM


All times are GMT +1. The time now is 02:34 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"