Sending mail with text and a field in the body

[Ben Simpson]

I am wanting to set up a SendMail scrip where in the body I want it to have both text and insert information from a field of the current record, but am unsure as to how to write this up. If, let's say Table::jobtitle is the record I want inserted, I would want the body to look something like this:

Table::jobtitle is now available for you to view for approve.

What I thought I could do is write up a calculation that says: Table::jobtitle and "is now available for you to view for approve."

When I send the message, though, all that is in the body of the message is a 0.

Any thoughts?

[comment]

'And' is a logical operator. Try:

Table::jobtitle & " is now available for you to view for approve."

[Ben Simpson]

That did the trick. Thanks for the help.

[comment]

I am glad to hear that. Perhaps you should also review the syntax of " is now available for you to view for approve."