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,137
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,158
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, 4 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,137
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,137
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,137
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,137
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
Please reply to this thread with any new information or opinions.

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:35 AM.


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