Solved

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

Posted on 2013-11-25
3
264 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
Comment Utility
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
Comment Utility
The List function works in putting hard returns between lins of data.  Thanks, Will.
0
 
LVL 24

Expert Comment

by:Will Loving
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

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…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 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

9 Experts available now in Live!

Get 1:1 Help Now