When mail merging an exported file from Crimson into a Microsoft Word template (i.e. Thank you letters), you may need to update the settings for the amount fields in order for them to be formatted correctly in your letters and allow for up to two decimal places to display. Follow the steps below to ensure that the amount fields are mail merged in the correct format.
- Leave your Excel file’s amount field formatted as a money type field.
- Create your Microsoft Word template/document for the mail merge like normal.
- You will likely have an amount insert that looks similar to the example below. Use your mouse to hover over that amount insert field and right click on it.
- Select “Toggle Field Codes” from the amount field drop-down menu.
- The line should appear like this now:
- Add the following to the rule: \# $,#0.00x and the line should appear like this now:
- Right click on the insert field and toggle it back to the normal view.
- Proceed like normal with your mail merge.
Below is an example of how the amount fields should appear after you have updated the settings for those fields for the mail merge.