Send Mail Script: Message Body

[Matt Leach]

This is my first time attempting to use the Send Mail script and im having some difficulty.

The script is functional and works except for the message portion. Iwould like to include some text of my own and have it pull some information from the tables. I wrote out my message and then went back and used the Specify Field Name option and it seems to overwrite my text.

Is it possible to do such a thing or are yo limited to one or the other. If it is posssible, what am i doing wrong?? Do the field names need to be contained with special characters?

Thanks

[mr_vodka]

TRy specify calculation instead.

[Matt Leach]

TRy specify calculation instead.

Would you be so kind as to providing an example of this?

I tried using a specific calculation you mentioned in the following manner and am receiving errors as i was before. This is what i have entered in as the calculation for the opening of my email:

Dear Claimant::Adjuster

whereas the Claimant::Adjuster is the field i a trying to pull the name from. The error that i am receiving is:

"The specified table cannot be found."

Im pretty sure there is something simple i am missing.

[comment]

Try:

"Dear " & Claimant::Adjuster

Hopefully you see the pattern here.

[Matt Leach]

Thank you for the reply, thats exactly what i was looking for. So anytime a field needs to be called it needs to be started with the & symbol and plain text needs to be enclosed in quotes, correct?

[mr_vodka]

So anytime a field needs to be called it needs to be started with the & symbol and plain text needs to be enclosed in quotes, correct?

I think you may kind of have it but I will clarify it a little better for you. Its not that you have to precede ALL fields with &

For example, you can have: Claimant::Adjuster & " is the main one"

The & sign is an operator for concatenation. It joins your string in this case "Dear " and the field Claimant::Adjuster.

Technically you can even have it just concatenate strings and no fields:

"Dear Mr. Bob" & " what is " & "this?"

and it will return

Dear Mr. Bob what is this?

or just fields

Claimant::Adjuster & Claimant::Adjustee

will return TonyBill where Tony is the value in the Adjuster field and Bill is the value in the Adjustee field

[Matt Leach]

I appreciate you time and help. This really cleared things up for me. I was under the impression that the & symbol was only needed for fields but after reading your reply and toying around in the script i was able to accomplish what i was trying to do.

Thanks again for your patience and help.

[comment]

You really ought to read the help sections from here:

http://www.filemaker.com/help/html/create_db.8.34.html#1030528