Mail Merge

otuatail · #1 10-31-2020, 07:08 AM

I am stil tusing office 2007. Still hapy with it. I want to do some kind of mail merge. I have Avery J8173. I have started with my fixed document with 1cm all around. Gone to mailing and...

Labels -> Avery A4 -> J8143 -> new document.

I did a test brint of a blank page to see if their was a margin problem. That was ok.

I want to make labels for wine bottles and have designed a label with an image of grapes and fancy fonts. What I want is to duplicate these over the other nine labels. I am not using excel as part of the mail merge as i am using images and I don't know if that would be possible in excel. Have uploded my sample with one filled in label. Wine is due for bottling next week so any help would be apreciated.

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

otuatail · #3 11-01-2020, 04:13 AM

Thanks for that. Never used macros before so will have a go with this and get to understand macros.

Charles Kenyon · #4 11-01-2020, 06:22 PM

Graham's site also has instructions: Instructions for Installing Macros from Forums or Websites

macropod · #5 11-01-2020, 10:04 PM

Quote:

Originally Posted by otuatail

I want to make labels for wine bottles and have designed a label with an image of grapes and fancy fonts. What I want is to duplicate these over the other nine labels. I am not using excel as part of the mail merge as i am using images and I don't know if that would be possible in excel.

So, if it's a mailmerge, simply connect to the Excel data source, choose 'labels' as the mailmerge type, configure the first label with the required mergefields, etc., then click on 'update labels'. Done. You're now ready to do the merge.

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