Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-10-2018, 11:36 PM
briffdogg briffdogg is offline Windows XP Office 2013
Novice
 
Join Date: Mar 2018
Posts: 2
briffdogg is on a distinguished road
Default pleasse help mail merge label formats

hello i bought these different labels and tried using these avery formats for mail merge but the margins are off and i been trying to fit it for endless hours and days, can someone please tell me how to fit them in please here are the labels i have, im using the avery formats i found on labelplanet label search L7409 avery code but it doesnt fit exactly how can i fix it please
Attached Images
File Type: jpg rsz_1rsz_img_6295.jpg (197.5 KB, 10 views)
Reply With Quote
  #2  
Old 04-11-2018, 05:19 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,355
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

My eyes are not what they were, but I cannot see what labels you actually have. The illustration shows lots and you will need the Word template that most closely matches what you have.

As these are clearly not Avery labels and don't appear to have the margins that Avery labels have, you will need a ruler and the label sheet and some plain paper of the same size.

Change the options for the label that is closest to provide the correct layout. Create a new document and add borders to the table before printing on plain paper.

Then hold the paper over the label so that you can see where the alignment is out. Make adjustments and try again.

You may need a few attempts before you get a usable template.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 04-21-2018, 07:23 AM
Moonshine Moonshine is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2018
Posts: 6
Moonshine is on a distinguished road
Default

briffdogg

If your labels are the ones with the 51 sticker on top of them, then they are 70 x 16.9mm in size.
The L7409 size you refer to is 57 x 15mm in size.

If this is the case, that would explain the problem.
Try the Avery Zweckform 3420

Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Customising label size in mail merge John guyon Mail Merge 1 11-25-2017 11:37 PM
Custom Mail Merge Label Template dazwm Mail Merge 20 11-21-2017 04:42 AM
Label Mail Merge Costco25 Mail Merge 1 12-01-2016 03:25 PM
Editing a mail merge label Colonel Biggs Word 6 03-22-2015 07:09 AM
How to start a label mail merge at a specific label? DHKaplan Mail Merge 2 04-17-2014 07:33 PM


All times are GMT -7. The time now is 10:11 PM.


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