Solved

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

Posted on 2013-11-25
3
266 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 24

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 24

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

919 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now