#1
|
|||
|
|||
Custom Mail Merge Label Template
I have a sheet of labels 2 across x 3 down. I cant use the stock L7166 template as the labels are round and won't print in the correct place. I will be taking the info from an Excel file. How would I be able to create a custom sheet please with the correct positioning for each row of labels?
|
#2
|
||||
|
||||
The fact the labels are round doesn't mean you can't use the L7166 labels; simply format the content to fit within the prescribed circles. See, for example, the attached.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I did try on a 7166 label but when I put the data in the top row as required the bottom labels when onto the next page. Can what you sent be saved as a template?
|
#4
|
|||
|
|||
Well I did try using as a template but it only put the data on the top LH label on each sheet?
|
#5
|
||||
|
||||
L7166 is a built-in label format under Avery A4/A5 options, though of course the circles that Paul has added are there solely as a guide.
Frankly because of the circular shape I would align the text to the centre of the label to avoid spillage, but you can work directly from Word's label L7166 format.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#6
|
|||
|
|||
I also got this error when I tried it?
|
#7
|
|||
|
|||
If I try to move the second and third rows down a little and select update labels, they revert back to the place they were?
|
#8
|
||||
|
||||
Sure; that's what you use Save As for. However, for mailmerges, you don't use templates anyway - you use a mailmerge main document.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Recap:
It looks like normal L7166 will work, however to line each row up as they should be the 2nd and 3rd rows need moving down a little. But as stated in post 7 when I try this and select 'update labels' they jump back to where they were? As the bottom 2 rows won't go in the correct place I have tried moving the text in the top row down so they all move down, but the bottom row goes onto the second page and so on.. |
#10
|
||||
|
||||
Simply use a separate paragraph for each line and choose an appropriate 'space before' setting for the paragraphs concerned.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#11
|
|||
|
|||
Sorry I don't understand.
|
#12
|
||||
|
||||
Which part don't you understand?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#13
|
|||
|
|||
All of it! I think what you are saying might be what I tried but they revert back to what they were before when I update labels.
|
#14
|
||||
|
||||
Surely you know how to insert a paragraph break???
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#15
|
|||
|
|||
No, should I? I thoughts that what I come on here for help.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to start a label mail merge at a specific label? | DHKaplan | Mail Merge | 2 | 04-17-2014 07:33 PM |
Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? | brunofirst | Mail Merge | 7 | 02-27-2014 02:30 PM |
Creating custom label fill-able template | JWaa@Auroracasket | Word | 2 | 12-13-2013 10:48 AM |
Custom label template | jdjette | Word | 0 | 02-02-2012 09:19 AM |
Custom label size for merge | dmwesq | Mail Merge | 13 | 04-24-2011 02:36 PM |