View Single Post
 
Old 04-25-2023, 07:48 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2019
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

Just enter all the relevant fields on the label. If there is no data in the field for a particular record nothing will print on the label.

I there are gaps, then conditionally insert the field e.g.
{ MERGEFIELD CUSTOMER }{IF { MERGEFIELD FIELDNAME1 } <> "" "
{MERGEFIELD FIELDNAME1 }" }{IF { MERGEFIELD FIELDNAME2 } <> "" "
{MERGEFIELD FIELDNAME2 }" }ETC


Mail merge labels with Microsoft Office covers the merge process, although originally written for an earlier Word version, the process remains similar.
__________________
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