Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-11-2017, 03:26 AM
dazwm dazwm is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: May 2012
Posts: 58
dazwm is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 09-11-2017, 04:31 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,526
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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.
Attached Files
File Type: docx CircleMerge.docx (31.8 KB, 2 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 09-11-2017, 04:46 AM
dazwm dazwm is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: May 2012
Posts: 58
dazwm is on a distinguished road
Default

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?
Reply With Quote
  #4  
Old 09-11-2017, 04:52 AM
dazwm dazwm is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: May 2012
Posts: 58
dazwm is on a distinguished road
Default

Well I did try using as a template but it only put the data on the top LH label on each sheet?
Reply With Quote
  #5  
Old 09-11-2017, 04:55 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,198
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

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)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #6  
Old 09-11-2017, 04:57 AM
dazwm dazwm is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: May 2012
Posts: 58
dazwm is on a distinguished road
Default

I also got this error when I tried it?
Attached Images
File Type: jpg Capture.JPG (19.2 KB, 7 views)
Reply With Quote
  #7  
Old 09-11-2017, 05:13 AM
dazwm dazwm is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: May 2012
Posts: 58
dazwm is on a distinguished road
Default

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?
Reply With Quote
  #8  
Old 09-11-2017, 05:15 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,526
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by dazwm View Post
Can what you sent be saved as a template?
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
[MS MVP - Word]
Reply With Quote
  #9  
Old 09-11-2017, 05:23 AM
dazwm dazwm is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: May 2012
Posts: 58
dazwm is on a distinguished road
Default

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..
Reply With Quote
  #10  
Old 09-11-2017, 11:49 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,526
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Simply use a separate paragraph for each line and choose an appropriate 'space before' setting for the paragraphs concerned.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #11  
Old 09-12-2017, 12:15 AM
dazwm dazwm is offline Windows 10 Office 2010 64bit
Advanced Beginner
 
Join Date: May 2012
Posts: 58
dazwm is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Simply use a separate paragraph for each line and choose an appropriate 'space before' setting for the paragraphs concerned.
Sorry I don't understand.
Reply With Quote
  #12  
Old 09-12-2017, 12:16 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,526
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Which part don't you understand?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #13  
Old 09-12-2017, 12:18 AM
dazwm dazwm is offline Windows 10 Office 2010 64bit
Advanced Beginner
 
Join Date: May 2012
Posts: 58
dazwm is on a distinguished road
Default

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.
Reply With Quote
  #14  
Old 09-12-2017, 12:18 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,526
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Surely you know how to insert a paragraph break???
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #15  
Old 09-12-2017, 12:32 AM
dazwm dazwm is offline Windows 10 Office 2010 64bit
Advanced Beginner
 
Join Date: May 2012
Posts: 58
dazwm is on a distinguished road
Default

No, should I? I thoughts that what I come on here for help.
Reply With Quote
Reply

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


All times are GMT -7. The time now is 07:29 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft