Emailing Using Filemaker

[Jon]

I need to script an email automation. Now when I want to be able to email a certain group of people in records, I have to do a look-up then export a .csv file and copy and paste from excel. How can I automate this so that I can cut the cutting and pasting out? Any ideas?

[Gerd Muller]

Use the script command "open URL" to open a new e-mail message in your favorite e-mail program.

The URL could be the following:

"mailto:" & emailadress & "?cc=" & CCadress & "?bcc=" & BCCadress & "?subject=" & subjectfield & "&body=" & bodyfield

If you want to send one email to several adresses, use only the BCCadress, and separate the e-mail adresses by comma (loop-script copying the adresses in a global). So the recievers don't see the adresses of all the other recievers.

Text in the subjectfield and in the bodyfield have to be cleaned from special characters such as < > CR.

Gerd