script to send text from FMP field via email

[ChangeAgent]

I need a script to send an email to a person and take, at random, the text out of a specific field in a FMP 6 data base.

I am not good at scripting and so far my attempts have failed.

Does anybody have any ideas?

Here is the mail script I use that works fine to sent fixed text:

set theSubject to "Subject" --change me

set theBody to "Body" --change me

set theTarget to "[email protected] " --change me

tell application "Mail"

set newMessage to make new outgoing message with properties {subject:theSubject, content:theBody}

tell newMessage

make new to recipient at end of to recipients with properties {address:theTarget}

set sender to "Me " --change me

end tell

send newMessage

end tell

[grumbachr]

I don't have a copy of FM 6 that I can open and check but does it have the script step of Open URL?

If so I can help a little more.

[ChangeAgent]

Greetings grumbachr

It has two URL commands in the library.

- getURL v Open a FileMaker Pro database using a URL specification

- getURL string : The URL specification for the FileMaker Pro database in the form "FMP5://[host]/filename"

is this what you are looking for?

And thanks for thinking with me.