I am trying to create one merge template that can be used worldwide. After searching, it doesn't appear that there is a way to insert a formula/switch/etc to have the date/currency fields format based on the regional settings of the user. But I wanted to just make sure before I give up. Our software application provides merge contracts and proposals to our users. Currently, we allow customers to edit their own merge templates so they can format the dates/currency formats. But we are trying to provide a single set of templates for our limited service product that does not allow them to edit. Any ideas?

You could use custom document properties named, for example, Currency, ShortDate, LongDate, etc. and insert into them the field picture switches you want to use in a given locale. The mergefields, etc. could then be coded along the lines of:
{MERGEFIELD Amount \#"{DOCPROPERTY Currency}"}
In this example, if the 'Currency' custom document property contained €,0.00, the output would be formatted as €1,234,56.

Another approach would be to employ a macro that queries the regional settings upon opening the mailmerge main document and automatically updates those properties for you.

Both approaches have their advantages and disadvantages.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]