MS Word Mail Merge Tech Tip: Numeric Fields Not Displaying Currency Sign

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

Numeric Fields Not Displaying Currency Sign when doing a mail merge.

Solution:

TECH TIP: NUMERIC FIELDS NOT DISPLAYING CURRENCY SIGN http://www.as400network.com/nwn/story.cfm?ID=9726

To change the format of a field merged into an Microsoft Word document, do the following:

• Press ALT-F9 to view field codes. Doing so will display merged fields as follows:

{MERGEFIELD PAYROLL_AMOUNT}

• Add a field switch to set the format you want. For example,

{MERGEFIELD PAYROLL_AMOUNT\# $#,##0.00}

will display the merged field from the Access Database (linked to a DB2/400 table) with a dollar sign and commas.

For additional information, search MS Word's Help menu's field switches category.