Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Control which email address is used by FileMaker' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Control which email address is used by FileMaker
Authored by: jporten on Aug 16, '04 03:09:05PM

If you need greater control over sending mail than what's available in FMP scripting, there's always AppleScript. You can target a new message from any account, and drive it with data in FMP fields.

My procedure for doing this:

1) write a working script in Script Editor

2) paste script into BBEdit

3) in order, replace " with \"; replace \r with ¶"\r"; add a quote at the beginning and end of the file. (All of these quotes are literals; type quotes where you see them. The semicolons are grammatical, do not type them. You're escaping the existing quotes, and adding CRs and quotes at every line break. ¶ is option-7. If you're using FMP <7, use "" instead of \" .)

4) paste the result into a calculated global.

5) edit in the FMP fields as necessary. Be sure to wrap FMP fields in \" & [field] & \" .

Works like a charm; lets you debug the script first, then translate it programmatically for FMP usage.



[ Reply to This | # ]