View Single Post
 
Old 09-25-2018, 02:43 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,925
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

First, get rid of all those \*charformat switches - you don't need them.

Second, make sure there's a space before and after "No".

You should how have:
{IF{MERGEFIELD "Use_Billing_Address"}= "No" "{MERGEFIELD Site_Name"}
{MERGEFIELD Site_Add_1}
{MERGEFIELD Site_Add_2}
{MERGEFIELD Site_Add_3}
{MERGEFIELD Site_Add_4}
{MERGEFIELD Site_Add_Post_Code}" "{MERGEFIELD Billing_Address_Contract_Name}
{MERGEFIELD Billing_Address_Line_1}
{MERGEFIELD Billing_Address_Line_2}
{MERGEFIELD Billing_Address_Line_3}
{MERGEFIELD Billing_Address_Line_4}
{MERGEFIELD Billing_Address_Postcode}"}
where the is a paragraph break or line break.

For the empty line suppression, see the corresponding topic in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote