May 13, 200916 yr Hi, I am using FM 10 Send Mail. In the message box I have placed the following information: "Dear "&applicants::first&" "&applicants::last&",¶¶" & "Congratulations on your appointment as an ALC Elementary Nurse for Summer Session 2009. You will be working for the following program(s): " & applicants::SITE_ASSIGN1_NAME & applicants::SITE_ASSIGN2_NAME The applicants first-last fields are text fields and I am having no problems formatting a SPACE between them . The Applicant Site Assign fields are calculation fields and while I do see the field information when sending the email and I am having no luck trying to format 1SPACE between SITE_ASSIGN1 and SITE_ASSIGN2 .... How do I do that ? Thanks, Jim
May 13, 200916 yr Shouldn't it be... "Dear " & applicants::first & " " & applicants::last & ",¶¶" & "Congratulations on your appointment as an ALC Elementary Nurse for Summer Session 2009. You will be working for the following program(s): " & applicants::SITE_ASSIGN1_NAME [color:purple]& " " & applicants::SITE_ASSIGN2_NAME
May 13, 200916 yr Well, the calculation you posted does not HAVE a space between them, whereas your first & " " & last does.
May 13, 200916 yr Author Hi, You guys are genius ...that did the trick .... now ...How do I "slip" back into narrative text after the last field formatting SITE_ASSIGN2 i.e. SITE_ASSIGN2_NAME SometextSometextSometextometext What goes in-between the field SITE_ASSIGN and Sometext :? Thanks for your help and quick replies....
May 13, 200916 yr SITE_ASSIGN2_NAME & " some text " Basically any literal text should be in quotes... The '&' sign "connects" the fields, functions, and literal text.
Create an account or sign in to comment