Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
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…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
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…

792 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