Define a table with two text fields: ImportHTML, ExportHTML. Link it in a relationship to the table where your data is stored Such that it matches to the record where your data is stored. You might add a global date field that matches to the NewsDate field, for example.
Set up an auto-Enter calculation for ExportHTML similar to this:
Substitute ( ImportHTML ; ["<<NewsTitle>>" ; YourTable::NewTitle] ; ["<<NewsDate>>" ; YourTable::NewsDate] //add substitution criteria like this for every field referenced in the HTML file)
Select the date in your global field first, then use Import Records to import your HTML file data into your table with the auto-entry options enabled. Then export your data from ExportHTML back out as a new HTML File.
cool I'll try that