asked on FM - Hard Return in Field not Showing in Some Lines in Email
In the past, I've found that returns in an SMTP script show up inconsistantly, so my workaround has been to put them in a field and then pull the field into the email script. This has worked 100% of the time so far, but just noticed that 2 of the 14 did not put a return before "Last Note" and thus last note continued on the previous line. Any thoughts?
" ¶" & LEASETRACK::PropCode & "; " & Month ( LEASETRACK::depositDate ) &"/" &
Day ( LEASETRACK::depositDate) &"/" & Right (LEASETRACK::depositDate ;2 ) &
"; " & LEASETRACK::typeOfBusiness
"¶" &
If ( IsEmpty ( LT_NOTES::NOTE ); "[No Notes]";
"Last Note: " & Month ( LT_NOTES::CrDate ) &"/" & Day ( LT_NOTES::CrDate ) &"/" & Right ( Year (LT_NOTES::CrDate ) ;2 ) &
"; " & LT_NOTES::NOTE )
& "¶------------------------
" ¶" & LEASETRACK::PropCode & "; " & Month ( LEASETRACK::depositDate ) &"/" &
Day ( LEASETRACK::depositDate) &"/" & Right (LEASETRACK::depositDate ;2 ) &
"; " & LEASETRACK::typeOfBusiness
"¶" &
If ( IsEmpty ( LT_NOTES::NOTE ); "[No Notes]";
"Last Note: " & Month ( LT_NOTES::CrDate ) &"/" & Day ( LT_NOTES::CrDate ) &"/" & Right ( Year (LT_NOTES::CrDate ) ;2 ) &
"; " & LT_NOTES::NOTE )
& "¶------------------------
FileMaker Pro
Last Comment
Will Loving
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
The List function works in putting hard returns between lins of data. Thanks, Will.
By the way, there is a nice Custom Function called "date.format" http://www.briandunning.com/cf/893 which I use and which will simplify the creation of dates. Instead of using:
Month ( LEASETRACK::depositDate ) &"/" & Day ( LEASETRACK::depositDate ) & "/" & Right ( LEASETRACK::depositDate ; 2 )
you write it as:
date.format( LEASETRACK::depositDate ; "mm/dd/yy" )
This allows you to write it in any format you wish and using whatever separators.
Month ( LEASETRACK::depositDate ) &"/" & Day ( LEASETRACK::depositDate ) & "/" & Right ( LEASETRACK::depositDate ; 2 )
you write it as:
date.format( LEASETRACK::depositDate ; "mm/dd/yy" )
This allows you to write it in any format you wish and using whatever separators.