Hi all,

I have a very simple script (FM 10 adv Win XP) that is supposed to
send a mail regularly, and it works fine.
I would like to insert some numbers in the body of the mail. These
numbers are stored in 2 variables:

$NbNewRecords (= SomeField)
$NbGrandTotal (= SomeOtherFiled)

The message would be something like:

"Hello, in the last month we had $NbNewRecords enrollments, thus to
date, the total number is $NbGrandTotal"

Obviously, I would like to replace the $... with the actual number but
I cannot get it.
I tried different escape characters: \, ", or "" but I get something
like:

$NbNewRecords
$NbGrandTotal

or

"$NbNewRecords"
"$NbGrandTotal"

Might you help in this ?

Thanks always !

Diego

On Oct 11, 3:20*pm, Diego B <messa... (AT) yahoo (DOT) it> wrote:
You don't need to escape the variable, you're combining text strings
with variables. Concatenation is handled with an ampersand:

"Hello, in the last month we had " & $NbNewRecords & " enrollments,
thus to date, the total number is " & $NbGrandTotal "."

G

"Grip" <grip (AT) cybermesa (DOT) com> wrote

On Oct 11, 3:20 pm, Diego B <messa... (AT) yahoo (DOT) it> wrote:
Oops! A typo - you left out one concatenation & just before the "." at the
end.
i.e.
Hello, in the last month we had " & $NbNewRecords & " enrollments,
thus to date, the total number is " & $NbGrandTotal & "."


Helpfull harry )

On Oct 11, 7:16*pm, "Your Name" <your.n... (AT) isp (DOT) com> wrote:
Great !
Thank you so much for the advice, it works like a champ : )

Diego

On 12 oct, 08:42, Diego B <messa... (AT) yahoo (DOT) it> wrote:
Is there any way to add the variable into merge field ??

<<table::field>> & $variable <<table::field2>> ???

Or it's another no do with FM10 and will be in FM12 ?? :O)