,

---

The formulamerge statement merges data into a template.

---

Parameters

This statement has two parameters:

template – Text of template.

result – Output text (each formula has been replaced by its value).

---

Description

This statement merges data into a template. Within the template you can place formulas inside { and } characters.

This example assumes that the database has fields named Name, City and State (or that there are variables with these names).

local Letter
formulamerge "Dear {Name},"+cr()+cr()+
    "I am planning a visit to you in {sandwich("",City,", ")+State} next week.",Letter

The end result will be in the Letter variable, and will look something like this:

Dear John Watson,

I am planning a visit to you in San Francisco, CA next week.

If there is an error in the template the result will be:

FormulaMerge Error “error message” Template “template”.

---

See Also

• makemergeformula -- makes a formula from a template.
• makemergeformula( -- builds a formula from an “auto-wrap" style merge template.

---

History

Version	Status	Notes
10.0	No Change	Carried over from Panorama 6.0.