IWP Send Mail Help

[Jalz]

Hi Guys,

Ive got a very small database I am trying to develop in IWP. As its IWP and SendMail doesn't work in the web, I am utilising the Open URL command.

The output I am trying to do is create illustrated below. I can do this using the Email1 button (Send Mail). Email2 is the button I've created uses Open URL and everytime I've tried in a web browser its not fomratting the text like I would like, no matter what type of carriage returns I put at the end. I am working on a Windows XP machine using FMPA8 and so far testing in Outlook Express.

If anyone is interested in looking at my simplified datfile, the un and pw are both "test" in IWP.

*** THe output I would like generated using IWP ***

Company: test

Brief company details: This is a very small company,

Contact Name: Bill

Age: 49

Mobile: 07970 117657

Contact Name: Bob

Age: 45

Mobile: 07973 467908

Contact Name: Angelina

Age: 29

Mobile: 09876 548543

Contact Name: Barry

Age: 34

Mobile: 07493 769743

Thanks to all that respond

iwphcprototype.zip

[T-Square]

Jalz--

In order to use the Open URL command, you have to turn your message into a single URL. This means converting the characters that would be invalid in a URL (like the carriage return or space) into something valid. A while back I submitted a Custom Function to handle any such character, which is available at: http://fmforums.com/forum/showtopic.php?tid/172099/

Try it out and see how it works for you. All you have to do is copy the code to a new Custom Function, then create a calculated field that wraps your data with the function:

MySafeURL:

URLEscape(MySrcField)

Keep in mind that different browsers have different limitations on the length of a URL that they will process.

HTH!

David

[LelandLong]

For those of us who cannot make our own Custom Functions (since we can only afford FM8 and not FM8A or greater : can do the same thing with "Substitute" (replacing all colons, spaces and line feeds with Encoded Equivalents)

Using your supplied file I added a new calculation field "Portal Text3":

Substitute ( Substitute ( Substitute ( Portal Text2 ; ":" ; "%3A" ) ; " " ; "%20" ) ; "¶" ; "%0A" )

Also removed your paragraph marker at the end of your URL calculation to get the function to work correctly.

2 files enclosed, ignore the first, it wasn't complete :)

HCPrototype.fp7.zip

HCPrototype.fp7.zip