Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-27-2020, 06:35 AM
jcaswell jcaswell is offline Sticky Label mail merge Windows 7 32bit Sticky Label mail merge Office 2007
Novice
Sticky Label mail merge
 
Join Date: May 2011
Posts: 13
jcaswell is on a distinguished road
Default Sticky Label mail merge

I have used Excel and Word to merge my christmas card labels for a number of years. It has always proved tricky (probably because I forget what to do from one year to the next), but this year I am really hitting a problem that I hope someone can help me with.

I am using the mail merge wizard, and the results do not fit the sticky labels I have. I have even manually set the dimensions and layout of the label page. No luck - the spacing of the labels is consistently too small, so the printing drifts up.

It looks like they create a table and then insert the addresses into the table. I have inspected the table settings in Word, and the row height is correct (in this case 3.84 cm)



Even with that, the spacing is not correct. I have even drawn borders around the cells (see below) and printed off the page. When I have measured the depth of the cell, it is not 3.84cm but closer to 3.6 cm. That accounts for the drift upwards




So - somewhere between the formatting of the table and the printing the dimensions are getting mixed up. I have tried to inspect the printer settings incase it is in some way scaling the print. The cell width is also reduced from 10.03 specified to something slightly over 9.42 printed.



It seems to me that the mail merge programme is throwing something at the printer that it cannot pront, and so it is scaling it down to fit (I am specifying A4 paper, not Letter).

Any thoughts and suggestions?
Reply With Quote
  #2  
Old 11-27-2020, 11:38 AM
macropod's Avatar
macropod macropod is offline Sticky Label mail merge Windows 10 Sticky Label mail merge Office 2010
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

That suggests there is a mismatch between the page size and the paper size, and you have the 'Scale content for A4 or 8.5x11"paper sizes' option checked.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-27-2020, 11:41 AM
macropod's Avatar
macropod macropod is offline Sticky Label mail merge Windows 10 Sticky Label mail merge Office 2010
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

Cross-posted at: Word / Excel Mail Merge problems - Microsoft Community
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 11-27-2020, 01:45 PM
jcaswell jcaswell is offline Sticky Label mail merge Windows 7 32bit Sticky Label mail merge Office 2007
Novice
Sticky Label mail merge
 
Join Date: May 2011
Posts: 13
jcaswell is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
That suggests there is a mismatch between the page size and the paper size, and you have the 'Scale content for A4 or 8.5x11"paper sizes' option checked.

Thank you - that looks like the answer.


And sorry about the cross-posting - I had not realised that that is not viewed kindly
Reply With Quote
  #5  
Old 11-30-2020, 04:16 PM
Charles Kenyon Charles Kenyon is online now Sticky Label mail merge Windows 10 Sticky Label mail merge Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by jcaswell View Post
Thank you - that looks like the answer.


And sorry about the cross-posting - I had not realised that that is not viewed kindly
Sometimes cross-posting is needed, but it should not be immediate and you should follow the etiquette specified.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quickest way to create this Mail merge label Buzz26 Mail Merge 2 02-04-2020 01:39 PM
Customising label size in mail merge John guyon Mail Merge 1 11-25-2017 11:37 PM
Sticky Label mail merge Label Mail Merge Costco25 Mail Merge 1 12-01-2016 03:25 PM
Sticky Label mail merge Editing a mail merge label Colonel Biggs Word 6 03-22-2015 07:09 AM
Sticky Label mail merge How to start a label mail merge at a specific label? DHKaplan Mail Merge 2 04-17-2014 07:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:51 PM.


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