To remove from all cents (decimals) in amount fields in a Raiser's Edge Mail function:
  1. In the mail parameter (set-up), click on the Format tab.
  2. Highlight Miscellaneous in the left list.
  3. Unmark Show decimals.
  4. Click Save.
  5. If needed, click Merge or Send to Word merge wizard to proceed with mail merge.

OR

To remove all cents in the final merge document*:
  1. Click Ctrl and H to bring up the Find and Replace window.
  2. Click on Replace tab.
  3. In the Find what: field, enter .00
  4. In the Replace with: field, leave blank.
  5. Click Replace or Replace All.
  6. Review document to ensure the change completed correctly.

OR

To merge a specific field without the trailing cents*:

1. In the mail merge template, highlight the gift amount merge field (or desired amount field). This is the gift amount field in a gift export in the Blackbaud Simple Word Merge format:
User-added image
2. Right click on the field and select Toggle Field Codes.
User-added image
3. Insert the cursor before the final } bracket. Copy / paste or type the following before the final } bracket: \# $,#
User-added image
4. Right click on the field and select Toggle Field Codes to return the field to the merge field.

User-added image
5. From the merge in The Raiser's Edge, click Add-ins in the top menu bar and then Save and return to RE7. Complete the mail merge as needed. The field will appear as follows in the mail merge output:
 
Mail Merge template
User-added image

Mail Merge results
User-added image

 


For additional information on using switches to format merge fields, please refer to the following:

https://support.office.com/en-us/article/Field-codes-in-Word-b0536e6f-5a23-4408-b90f-e7fc24c75416

https://support.office.com/en-us/article/Insert-and-format-field-codes-in-Word-2010-7e9ea3b4-83ec-4203-9e66-4efc027f2cf3

*Note: Please contact the appropriate software vendor or IT professional for assistance with this process or issue which is beyond Blackbaud's scope of support. We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites and we cannot assist with implementing resolutions from these websites.