Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-22-2024, 07:23 PM
Marl Marl is offline Format Labels Windows 7 64bit Format Labels Office 2010 32bit
Novice
Format Labels
 
Join Date: Jan 2013
Posts: 8
Marl is on a distinguished road
Default Format Labels


How do I format the font in labels, and eliminate the space between address lines in Mail Merge? Is there a set of instructions that cover this?
Reply With Quote
  #2  
Old 02-29-2024, 01:41 AM
gmayor's Avatar
gmayor gmayor is offline Format Labels Windows 10 Format Labels Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
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

A simple way to eliminate blank address lines is to conditiionally insert the field and the line break e.g.
{ MERGEFIELD Field1 }{ IF { MERGEFIELD Field2 } <> "" "¶
{ MERGEFIELD Field2 } "}{ IF { MERGEFIELD Field3 } <> "" "¶
{ MERGEFIELD Field3 } "}
where ¶ is an actual paragraph break.

Labels are tables and are formatted like any other text in a table.
__________________
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
Reply

Tags
format labels



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge field mistakenly interpret text format as date format alan6690 Mail Merge 0 09-02-2020 01:54 AM
Format Labels word 2013 Labels - addresses overlapping into labels titch Word 2 03-08-2019 03:49 PM
Format Labels Can't format REF field (format first letter, use * CHARFORMAT doesn't work) Blaq Word 3 02-19-2019 04:49 PM
Format Labels Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match. PhillJ Excel 4 08-22-2017 03:10 AM
Format Labels Format:Fonts for Avery 5266 labels charlesh Word 2 01-20-2010 10:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:46 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