Microsoft Office Forums

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: 59
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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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, 9 views)
__________________
Cheers,
Paul Edstein
[Fmr 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: 59
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: 59
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: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
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: 59
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, 21 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: 59
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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr 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: 59
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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
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: 59
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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Which part don't you understand?
__________________
Cheers,
Paul Edstein
[Fmr 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: 59
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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Surely you know how to insert a paragraph break???
__________________
Cheers,
Paul Edstein
[Fmr 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: 59
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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:42 AM.


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