MERGEFIELD

  • 2 minutes to read

MailMerge field

{ MERGEFIELD “field name“ [ switch ] [\* MERGEFORMAT] }

When the main document is merged with the selected data source, information from the specified data field is inserted in place of the merge field.

The MERGEFIELD field supports the following switches:

Switch Description
\* MERGEFORMAT Retains the formatting applied to the field.
\b “text Specifies the text to be inserted before the MERGEFIELD field if the field is not blank.
\f “text Specifies the text to be inserted after the MERGEFIELD field if the field is not blank.

Example:

{ MERGEFIELD FirstName \f” “ }{ MERGEFIELD MiddleName \f” “ }{ MERGEFIELD LastName }

  • If the MiddleName field data is missing (null), then there is only one space between FirstName and LastName:

    David Bradley

  • Otherwise, MiddleName is separated by spaces as required:

    David M Bradley

If the merge field is replaced with a DateTime value and no formatting switch is specified, the actual display formatting is dependent on the FieldOptions.UseCurrentCultureDateTimeFormat option.

  • If this option is set to true, the system’s Date and Time settings will be used.
  • If the FieldOptions.UseCurrentCultureDateTimeFormat is false (the default value), DateTime values are displayed using the “M/d/yyyy” formatting.

The MERGEFIELD field is displayed as a placeholder when the ShowAllFieldResultsCommand command is executed, as shown on the image below:

Fields-Placeholder

Set the RichEditMailMergeOptions.ViewMergedData to true or execute the ToggleViewMergedDataCommand command to view the MERGEFIELD code result:

Fields-Result

See Also