Mailing: line break before merge field
m@rina Posted messages 27560 Registration date Status Moderator Last intervention -
Hello,
I am creating a mail merge for a letter that sometimes includes one requester but also two at times. My merge fields coming from Excel are working. I have one column with my requester 1 and a second column with my requester 2.
I would like to insert a line break before my requester 2 field. If I do it manually (in Word), I end up with a blank line if there is only one requester.
Do you know how to enforce a line break before a merge field? We can insert "text to insert before" but no line break.
Thank you in advance,
2 answers
-
Hello,
In Excel, you can insert a line break in a cell using CHAR(10). ="aaa"&CHAR(10)&"bbb" with a cell format set to wrap text will display the text on 2 lines. Perhaps CHAR(10) as text before?
-
Hello,
I had explained to you how to use an If... Then... Else field, preferably to be done manually. I accidentally deleted the post... :(
There is another simple solution which is to use a switch \b with the field Requester2, as I explain here:
However, if you don't want to insert this field but only the page break and some text if the field exists, you need the If... Then... Else:
{ If {MERGEFIELD Requester2 } <> "" ...............page break................¶
"text to add" "" }
I remind you that all the { } are created with Ctrl+F9
m@rina
