How do I setup and trigger email from Filemaker Server?

I'm having difficulty setting up and triggering email from Filemaker 9  Server Advanced.

My database has a table of emails that I want to send to students and centrally track.  I understand that there is a way to have these sent from the server directly using XSLT.  I have an xslt file and a table that stores emails to be sent.

The problem is that I have no idea how to make hook this up and make it work.

I tried adding a recurring script to lookup all unsent emails from the Email table and send them.  The problem, Is that I don't know what that script needs to contain of how to make it actually send the mail.  

My FM Pro Server says that XSLT is setup, but I have no clue where to put, or how to run the XSLT file.  No body in my group has ever used the advanced web features in Filemaker Server.   In that respect this is a beginner question.

Experts, thanks for any assistance you can offer. send-email-v2-ee-post.xsl
email-table1.png
email-table2.png
tmonteitAsked:
Who is Participating?
 
lesouefConnect With a Mentor Commented:
fmaker has an internal smtp client. all you need is change the 1st option (email client/smtp server)  in the send mail script command.
it will open up a new window to enter smtp server params.
once done and tested from a client, this script can be scheduled on server. of course the smtp server must accept requests from the fm server if it checks the sender's ip address.
0
 
lesouefCommented:
why do you bother doing it this way? quite unusual... I guess nobody here has ever been using a xml file to load an email list.
do a script which works manually, then schedule it in your server.
where is the list of receivers located?
0
 
tmonteitAuthor Commented:
It seems I may be making this harder than required.  Is there an example on how to do this?  
My confusion seems to be that the script tries to send the mail through a client like outlook.  I need to send the email from the server through an SMTP client.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.