malto: calclutation

[grumbachr]

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.

[MarkWilson]

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.

[grumbachr]

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.

[MarkWilson]

Well done, you have passed the test.