View Single Post
 
Old 03-06-2022, 04:52 PM
BernieB BernieB is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2022
Posts: 4
BernieB is on a distinguished road
Default Remove blank line from Directory MailMerge

Thank you Paul!

Yes this worked great and easier than IF statements.

My code now looks like this:
{QUOTE{IF{MERGESEQ}= 1 {SET Key ""}}"{IF{MERGEFIELD Organization}
<> {REF Key \* MERGEFORMAT } "{IF{MERGESEQ}> 1 ""}{ QUOTE 12 }
{MERGEFIELD Organization \* MERGEFORMAT }

{ MERGEFIELD Name \* MERGEFORMAT }{SET Key {MERGEFIELD Organization }}"
{ MERGEFIELD Name }}
{ MERGEFIELD Title \f"
"}{ MERGEFIELD Organization2 \f"
"}{ MERGEFIELD Address_1 \f"
"}{ MERGEFIELD Address_2 \f"
"}{ MERGEFIELD City }, { MERGEFIELD Province }
{ MERGEFIELD Postal_Code }}


Another question: Is there a way to put the comma between City and Province somewhere else in case there is no City or Province?

Thank you,
Bernie
Reply With Quote