Mail Merge

gmayor · #2 10-31-2020, 09:21 PM

It seems that all the labels would be the same? That being the case you can simply duplicate the first label on the rest and print as many copies as you need. A macro can simplify that e.g.

Code:

Sub DuplicateLabels()
Dim oTable As Table
Dim oField As Field
    With ActiveDocument
        .MailMerge.MainDocumentType = _
        wdMailingLabels
        WordBasic.MailMergePropagateLabel
        For Each oTable In .Tables
            For Each oField In .Fields
                If oField.Type = wdFieldNext Then
                    oField.Delete
                End If
            Next oField
        Next oTable
        .MailMerge.MainDocumentType = _
        wdNotAMergeDocument
    End With
lbl_Exit:
    Exit Sub
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tricky Mail Merge Labels	fairchance	Mail Merge	2	11-18-2015 06:17 AM
Help with a mail merge onto labels	dhause211	Mail Merge	1	07-14-2014 09:36 PM
Duplicate Labels During Mail Merge	melannewis	Mail Merge	2	07-25-2012 07:56 AM
Mail Merge - Labels	borislibman	Mail Merge	0	12-13-2009 07:24 PM
Labels Mail Merge	borislibman	Outlook	0	12-13-2009 07:23 PM