Brian Dunning's FileMaker Custom Functions

MailMerge ( text )

Allows mail merge style syntax for an end user to create their own letters in a field.

  Average rating: 4.1 (41 votes) Log in to vote

Mike Duncan   Mike Duncan
Duncan Creations
http://www.duncancreations.com

Share on Facebook Share on Twitter

  Sample input:
MailMerge ( Welcome, << name>>. You have been enrolled in << class>>. )
  Sample output:
Welcome, Mark. You have been enrolled in Math 101.

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This custom function lets you put field names in "<<" and ">>" that will be evaluated at runtime and display field contents. Useful for creating a template style system to allow users to create their own letters or email with merged data. Especially useful for creating dynamic emails without allowing the user access to the scriptmaker.

This also merges any function available, since it uses the evaluate function, so it's possible for your template to contain get(currentdate) for example, to display the current date.

 

Comments

Matthew   Matthew, Seattle
Jul 11, 2013
Works well. The text argument needs to be placed in quotes:

MailMerge ( "Welcome, <<name>>. You have been enrolled in << class>>." )
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.