Cust Num::NameFirst & " " &
" " & Cust Num::NameLast & "¶¶"
The above will give you two spaces after the first name. Remove one of the |& " "| areas. Don't put quotation marks around the two return characters.
There are actual pilcrow characters (the carriage returns) in your field. Try wrapping BR_LiveGlobals::BR_InvoiceEmailContentsAll with a substitute:
Substitute ( BR_LiveGlobals::BR_InvoiceEmailContentsAll ; "¶" ; "<br/>" )
That'll use the HTML equivalent of a carriage return. Sometimes Mail and/or Outlook will remove extra carriage returns if you use more than one in a row, so the HTML version can help preserve the formatting you want.
i1 = trim(substitute(Cust Num::NameFirst ;"¶";""));
i2 = trim(substitute(Cust Num::NameLast ;"¶";""));
i3 = trim(BR_LiveGlobals::BR_InvoiceEmailContentsAll)
];//end let variables
i1 & " " & i2 & "¶¶" & "Thank you" & "¶¶" & i3
If you still get unexpected output, make sure the ¶ that is being used both in this calc and in your BR_InvoiceEmailContentsAll field is the native pilcrow character that you can select directly from the filemaker calculation dialog.
- The trim function just removes leading and trailing spaces from the data supplied to keep your visual output consistent.
What I used was:
did the trick