This happens because Word formatting switches such as \* Caps and \* MergeFormat are not reliably applied during Apsona merges. Apsona injects the field values directly into the Word template, and Word’s formatting engine does not reprocess those values after insertion. As a result, capitalization rules defined inside merge fields are ignored, even though the merge completes successfully.
This is not an issue with Salesforce data or permissions, but a limitation of how Apsona performs document merges into Word templates.
To resolve this, the text transformation must be handled before the data enters the Word template.
The recommended solution is to use an Apsona Calculated Field to convert the address into Title Case.
For example, this JavaScript formula can be used in a calculated field:
{!Billing Street}.toLowerCase().split(' ').map(function(word) {
return word.charAt(0).toUpperCase() + word.slice(1);
}).join(' ');
Steps to implement the fix:
Open the report used for the merge.
Add a Calculated Field using the title-case logic.
Replace the original merge field in the Word template with the new calculated field.
Re-run the merge and confirm the output.
This correctly transforms:
123 sesame street → 123 Sesame Street