#1
|
|||
|
|||
Mail Merge - copying image to all labels
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. |
#2
|
||||
|
||||
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
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Thanks for that. Never used macros before so will have a go with this and get to understand macros.
|
#4
|
|||
|
|||
Graham's site also has instructions: Instructions for Installing Macros from Forums or Websites
|
#5
|
||||
|
||||
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
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 |