Thread: [Solved] Mail merge line break
View Single Post
 
Old 06-29-2011, 05:16 AM
camlad camlad is offline Windows 7 Office 2010 (Version 14.0)
Novice
 
Join Date: Nov 2010
Posts: 6
camlad is on a distinguished road
Default

Thanks Paul but I don't see how I can do what I want with that.
What I am after is:
within an 'IF' statement I need to include a paragraph mark if TRUE in order to put the next part of te address on the next line but I dont want a paragraph mark if the field is FALSE (blank).
So, I should like the lines to look something like this:

{ MERGFIELD Address1 }{ IF { MERGFIELD Address2 }<> “” { ^p
MREGEFIELD Address2 } “” }{ IF { MERGFIELD Address3 }<> “” { ^p
MREGEFIELD Address3 } “” }{ IF { MERGFIELD Address4 }<> “” { ^p
MREGEFIELD Address4 } “” }{ IF { MERGFIELD Postcode }<> “” { ^p
MREGEFIELD Postcode } “” }
Reply With Quote