Solved

FM - Hard Return in Field not Showing in Some Lines in Email

Posted on 2013-11-25
3
269 Views
Last Modified: 2013-12-03
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 & "; " & LEASETRACK::Commissioned Agent & 
 "¶" & 
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  )
 &  "¶---------------------------------"
0
Comment
Question by:rvfowler2
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39676711
I have no idea why they would not show up, but I would suggest - as an experiment - to  trying the List() function instead of using explicit carriage returns.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 39692835
The List function works in putting hard returns between lins of data.  Thanks, Will.
0
 
LVL 25

Expert Comment

by:Will Loving
ID: 39693041
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.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question