Sending email from IWP

[sudhakar]

Hi friends,

I have some proplem with sending email from IWP. I have published my database through IWP. What i have to do is i have select some particular set of records from a table and i have to send those records to an email ID(this is also from a table). All these things has to happen when a click a button control. From IWP how can i implement this fuctionality. IWP does not support Send Mail script.

please help me.

[Søren Dyhr]

We use this in our solutions:

http://www.cnsplug-ins.com/products.htm?product=SMTPit

--sd

[xochi]

According to the developer, SMTPit doesn't work under FM7 Server Advance on Mac... are you using windows or a stand-alone FM7?

[Søren Dyhr]

I'm not aware of the actual details beyond, knowing that it in the setup I know of works, probably by burdensharing between machines.

You might get away by something in the vicinity to this, that I as non subscriper of

http://www.filemakermagazine.com/modules.php?op=modload&name=News&file=article&sid=581&mode=thread&order=0&thold=0

...can't tell you about, except some guessing. At least could something be achieved this way:

http://www.briandunning.com/filemaker-custom-functions/detail.php?fn_id=194

http://bbs.applescript.net/viewtopic.php?id=12703

--sd

[CyborgSam]

The Script Step OpenURL works, the syntax for email is:

mailto:[email protected]?subject=Put your subject here&Body=Put your body here

The Subject and Body are optional.

?s and &s cannot be part of the text since they are reserved characters in the URL, so use Substitute to eliminate them. I use this calc:

Substitute ( Substitute (

"Your text here"

; "?" ; "--QuestionMark--" ); "&"; "--Ampersand--")

[xochi]

I'm guessing that would have the same problem with popup-blockers (such as Safari) that the Open URL script step has.

On a mac, another way to accomplish this may be via AppleScript that either talks directly to Mail.app, or else calls a shell script... Anyone tried this?

Word is that the SMTPit won't work on mac / FM7SA because of a bug with plugins in FileMaker. Let's all hope that FM fixes the bug soon!

[CyborgSam]

Using OpenURL with mailto: will not suffer from popup-blocking, only http: and https:, which are passed to a web browser, are affected by popup-blocking.

Normally, the mailto: is passed to Mail.app, OS X can also be configured to open Entourage, Eudora, at al. as the email application (using something like the More Internet preference pane).