Solved

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

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Filemaker Display Images 1 252
Filtering portal results 3 82
Printing Portal records 15 140
FM - Efficient Method of Sorting Portals Yet? 2 68
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…
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…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 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