exporting and html coding

November 1, 200223 yr

I want to be able to export a single document with the formatting I designed.

Can I use HTML codes to keep the formatting the same? Can I add HTML into

a script? How do I this? My goal is to export a single record and turn it into

an e-mail with HTML formatting.

Can I do this? Would I need Filemaker Pro Web Companion?

The email set-up that is with the filemaker script does not have all the bells

and whistles I need to create the necessary formmatting. Can anyone Help?

Thanks

Paul

November 2, 200223 yr

I know that FM version 6 has a lot of XML capabilities, but I haven't looked into it. A very simple way to do it with any version of FM is to create a global text field that contains a template of the HTML (which you can create in another application), with dummy text markers where you want to insert the actual data. Then use a series of substitute functions to create the actual output. Suppose your template field is gTemplate and contains something like:

<Htmlblah> MyDummyMarker1

<blah>

<Html tag> MyDummyMarker2

<blah>

<Html tag> MyDummyMarker3

<blah>

Then make a calculated field cOutputHTML with this formula:

Substitute(Substitute(Substitute(gTemplate,

"MyDummyMarker1",DataField1),

"MyDummyMarker2",DataField2),

"MyDummyMarker3",DataField3)

This will then be the actual HTML that you want to export.