|
MailMergePlus ( text ; highlight)
Peter Vinogradov, peter vinogradov consulting
http://www.petervinogradov.com
Mailmerge function that preserves formatting of source text
Sample Input:
| MailMergePlus ( "Dear <<FirstName>>, Welcome to <<SchoolName>>..."; 1) |
|
Sample Output:
| Dear John (in blue), Welcome to Cambridge University (in blue)... |
|
Description:
A recursive function that replaces bracket-enclosed (<<>>) formulae or field references with evaluated results. Works similarly to Mike Duncan's "MailMerge" function (http://www.briandunning.com/cf/438).
Because it does not evaluate the entire output string, This method preserves formatting of the source text (including the format of the merge field/formula based on the format of the first bracket).
The "highlight" switch is used to return a blue coloration for the results of any merge fields/formulae. If this parameter is set to null ( "" ), then no special formatting is applied. This feature is useful for giving users a way to easily check the output of their merge letter.
Edit: Oops, just discovered that my merge formula is very similar (coincidentally, I swear) to the one in this function: http://www.briandunning.com/cf/826
That one uses getfield() instead of evaluate, which is a good way of restricting the functionality so that users can't execute arbitrary calcs.
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
|
digg this page | del.icio.us this page
Newest Custom Functions:
 |
Custom Function Authors:
Link to all of your own custom functions on this site with the following URL:
http://www.briandunning.com/filemaker-custom-functions/results.php?author=Your
Name Here
|
