Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-07-2020, 04:12 AM
gmayor's Avatar
gmayor gmayor is offline Excel to Word Using Mail Merge Windows 10 Excel to Word Using Mail Merge Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,138
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 ofgmayor has much to be proud of
Default

Your preset formatting is not a standard label format. It has rows of differing heights and they differ because the text will not fit the 2.54cm row height and you have the row height set to at least 2.54 rather than exactly 2.54.

In order for this to stand a chance of working you are going to have to use a smaller font with reduced spacing between the paragraphs (say 9 pt Calibri) or you are going to need a bigger label stock.

I assume that you will want different numbers of each label according to the records, in which case the easiest way to handle that and avoid a lot of programming, would be to add the requisite number of records. You can then run a simple mailmerge using your label document as the merge document.



__________________
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel to Word Using Mail Merge Excel to Word Table via Mail Merge ged147 Mail Merge 4 11-28-2018 02:52 AM
Excel to word Mail Merge problem mark_kofi Mail Merge 4 07-17-2018 03:49 PM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA RMerckling Mail Merge 16 05-17-2018 05:19 PM
Excel to Word Using Mail Merge Word Mail Merge with Excel Graph s.unsworth Mail Merge 2 11-21-2014 05:57 PM
Mail merge table from Excel to Word krezumica Mail Merge 2 03-06-2014 10:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:38 AM.


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