Microsoft Office Forums Custom Mail Merge Label Template

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2017, 03:26 AM
dazwm dazwm is offline Custom Mail Merge Label Template Windows XP Custom Mail Merge Label Template Office 2007
Advanced Beginner
Custom Mail Merge Label Template
 
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 Custom Mail Merge Label Template Windows 7 64bit Custom Mail Merge Label Template Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
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 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 Custom Mail Merge Label Template Windows XP Custom Mail Merge Label Template Office 2007
Advanced Beginner
Custom Mail Merge Label Template
 
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 Custom Mail Merge Label Template Windows XP Custom Mail Merge Label Template Office 2007
Advanced Beginner
Custom Mail Merge Label Template
 
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 Custom Mail Merge Label Template Windows 10 Custom Mail Merge Label Template Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,796
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
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) (2002-2019)
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 Custom Mail Merge Label Template Windows XP Custom Mail Merge Label Template Office 2007
Advanced Beginner
Custom Mail Merge Label Template
 
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, 10 views)
Reply With Quote
  #7  
Old 09-11-2017, 05:13 AM
dazwm dazwm is offline Custom Mail Merge Label Template Windows XP Custom Mail Merge Label Template Office 2007
Advanced Beginner
Custom Mail Merge Label Template
 
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 Custom Mail Merge Label Template Windows 7 64bit Custom Mail Merge Label Template Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
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 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 Custom Mail Merge Label Template Windows XP Custom Mail Merge Label Template Office 2007
Advanced Beginner
Custom Mail Merge Label Template
 
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 Custom Mail Merge Label Template Windows 7 64bit Custom Mail Merge Label Template Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
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 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 Custom Mail Merge Label Template Windows 10 Custom Mail Merge Label Template Office 2010 64bit
Advanced Beginner
Custom Mail Merge Label Template
 
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 Custom Mail Merge Label Template Windows 7 64bit Custom Mail Merge Label Template Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
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 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 Custom Mail Merge Label Template Windows 10 Custom Mail Merge Label Template Office 2010 64bit
Advanced Beginner
Custom Mail Merge Label Template
 
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 Custom Mail Merge Label Template Windows 7 64bit Custom Mail Merge Label Template Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
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 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 Custom Mail Merge Label Template Windows 10 Custom Mail Merge Label Template Office 2010 64bit
Advanced Beginner
Custom Mail Merge Label Template
 
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
Custom Mail Merge Label Template How to start a label mail merge at a specific label? DHKaplan Mail Merge 2 04-17-2014 07:33 PM
Custom Mail Merge Label Template 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
Custom Mail Merge Label Template 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 Mail Merge Label Template Custom label size for merge dmwesq Mail Merge 13 04-24-2011 02:36 PM


All times are GMT -7. The time now is 03:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft