I am trying to script a button to open a url and send email. I am following this format i found in another post.

mailto:[email protected]?subject=yourSubject&body=yourBody

but i would like to have the subject and body auto entered from fields in a database.

"mailto:[email protected]?&subject=table:c_subjectfield&body=table:c_bodyfield"

This doesn't work because it just enters the text i've entered.

Can this even be done?

Any suggestion would be greatly appreciated.

grumbachr,

"mailto:[email protected]?subject=" & table:c_subjectfield & "&body=table:c_bodyfield"

FileMaker, with a few exceptions, takes anything inside "quotation marks" as literal text. Remove the fields from within the quotation marks and add ampersands to string the new text together.

Thank you so much it works perfectly.

however there was one typo in your example.

"mailto:[email protected]?subject=" & table:: 3::c_subjectfield & "&body=" & table::c_bodyfield

this is now working for me with a variety of default e-mail clients. Mail.app, Thunderbird, and Eudora (only ones i've tested so far).

Thank you for your help.

Well done, you have passed the test.