Re: Automatically removing Next Record

You want your cake and your ha'penny :)
Propagate will only be available with the document type set to label, but
propagate will add the next fields also. Change the document type to label
propagate the labels, then change it back to form letter and with the field
content displayed (ALT+F9) use the replace function to replace ^d NEXT with
nothing. Then add NEXT fields to the cells where you require them. or leave
them off for a page of labels for each address.

The following macro will do all of this except add the next fields:

Sub DuplicateLabels()

'Change the document type to mailing label
ActiveDocument.MailMerge.MainDocumentType = _

'propagate the labels

'display the field codes so they can be removed
ActiveWindow.View.ShowFieldCodes = True

'search for and remove the {next} fields

'added by the propagation and which are not required
With Selection.Find
..Text = "^d NEXT"
..Replacement.Text = ""
..Forward = True
..Wrap = wdFindContinue
..Format = False
..MatchCase = False
..MatchWholeWord = False
..MatchWildcards = False
..MatchSoundsLike = False
..MatchAllWordForms = False
End With
Selection.Find.Execute replace:=wdReplaceAll

'revert the document type to a normal document
ActiveDocument.MailMerge.MainDocumentType = _

End Sub


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site
Word MVP web site
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

PeteB wrote:
> Ok, I got the fields in place, but the Propagate button is grayed
> out. I would like to roll out the same fields to every label without
> having to customize every label. Is that possible?
> The key here is that I don't want Next Record at all. I need the same
> address on every label.
> Thanks for the help.
> "Graham Mayor" wrote:
>> Create the label document first from the new document option in the
>> envelope/label wizard, then use this as the basis for a form letter
>> merge (rather than a label type merge). Put your next record fields
>> wherever you want them.
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>> My web site
>> Word MVP web site
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> PeteB wrote:
>>> I want to create multiple mailing labels for one record in my data
>>> source. How do I prevent the Next Record from automatically
>>> appearing when I create my labels?
>>> Do I have to remove them manually from all 29 labels?


Relevant Pages

  • Re: Missing labels
    ... Open the merge document and ensure that the document type is set to mailing ... This will correct the label format based on what you have in that first ... Word MVP web site ...
  • Re: labels 3-across same label across each column
    ... Having created and propagated the label merge document ... document type to 'Letters' from the merge toolbar, ... record fields from the second and third columns. ... Word MVP web site ...
  • Re: Labels-single spacing - how to make default Word 2007
    ... document and is essentially the same as starting from a label template). ... along the Mailings tab of the ribbon as you would if creating labels from ... or change the document type to 'labels' the space is not added. ...
  • Re: my labels arent merging
    ... Cancel the label selection dialog when it ... pops up and the document type remains selected as labels. ... Word MVP web site ...
  • Re: Labels-single spacing - how to make default Word 2007
    ... function of the Label Options dialog box when used with Mail Merge. ... The Mailings tab categorizes each primary process ... Regarding adding the "Main Document Setup" command to the QAT, ... change the document type to labels and then ...