I have run into an incompatibility between Filemaker Send Mail script function and Lotus Notes v6.5.5. The problem is that the To:, Subject: and Body: data does not map properly to the Lotus Notes email template. This problem has been identified in this forum and on Technet.

Several people have suggested using the Open URL script function:

[color:red]Open URL["mailto:[email protected]?subject=subjectdata?body=bodydata"]

I have tried this and it appears to works but in a limited manner. It appears that the Open URL function limits the number of characters that it will accept. If I have too many addressees or the body text is too long it will not create an email in Lotus Notes.

So, does anyone have any other suggestions. I really need this feature in my database. I will have 1-6 addressees and the body text will be 150-300 characters long.

All suggestions will be considered.

Rich

Do you need to use the client to send the email, if not you could look at using an email plug-in such as SmtpIt.

http://www.smtpit.com/index.htm

There is a 2083 character limit for URLs in IE on Windows (not that IE exists on OS X anymore).

Interestingly this was a real problem for embedding the data URL in the web viewer until FileMaker 9 when they changed the way FileMaker handles data URLs (maybe all urls) in the web viewer. Maybe the new FMP9 Architecture will allow you to send the mailto: call via a webviewer page load. FileMaker may parse it rather than IE, its a shot in the dark but worth a try. I am on OS X so can not test this.

best

Stuart

Edited August 19, 200817 yr by Guest

Thanks for the input Stuart. I am operating in an environment where the IT support is located remotely and we get little help on these matters. It is my preference that we use client email at this time.

Currently I am investigating the script functions: "Send Event" and "Send DDE Execute". I need to confirm the Lotus Notes commands for setting the Send To, CC, BCC, Subject, Body Text and Send.

I will continue my journey down this unfamiliar road.

Rich

We use Mac OS X with Lotus Notes and FMP 8.5 and 9.0. Categorically, Lotus Notes does not work with FMP's send Mail script. We've moved to using the mail.it plugin.

I don't believe Notes is compatible on Windows either.

My test of Open URL script step indicates that there is a maximum of 216 characters. If the total length of string exceeds 216 then a new message will not be created in my Lotus Notes App.

Could the Open URL function be performed in a the web viewer? How?

Edited August 20, 200817 yr by Guest

Hmmmmm,

Sounds to me like lotus notes itself will only handle 216 characters.

doubt you can get around that.