Fields contents in subject line

[cschmitz]

Quick question. I am setting up a script to preform several tasks and then send an email notice to let several employees that the tasks are done. Originally I had it set up through a Send Mail script step, but we have a mix of mail clients in our office (Mail, Entourage, Thunderbird) and FileMaker doesn't exactly play well with all of them.

 

I decided to use the open url script step and have it do a "mailto:blank@blank.com....etc" so that it would open in whatever the default mail client the user is using.

 

This works fine but there's something I can't quite figure out. In the subject i'd like to say: "Quote number: _____ converted to Sales order number: _______." and have it insert the quote number and sales order number from the current record. Normally I would just put the field names in the blanks on the Send Mail script step, but when creating the email via URL it won't let me insert the fields in the subject.

 

It works fine in the body, but it would be ideal if I could have the numbers in the subject line. Anyone know if this is possible and if so how to go about doing it???

[AHunter3]

Open URL ["mailto:"&YourTable::Email Address& "?Subject=Quote number:"&YourTable::QuoteNumber&" converted to Sales order number: "&YourTable::Sales Order Number& "&Body="& YourTable::Email Contents Field; no dialog]

[cschmitz]

Awesome! It worked like a charm. Thanks a bunch for the help. It's much appreciated.