Mail Merge Switch

[Steve C]

Hello,
I'm using the following switch for numeric fields in my mail merge, but i
also need one for currency ($) & percentages (%). Are there switches for
these as well?

{MERGEFIELD "field" \# 0.00 }.

 

[macropod]

Hi Steve,

To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this:
.. select the field;
.. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it.

Note: The '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# $,0.00;($,0.00);'-' for currency, with brackets around negative numbers and a hyphen for 0 values


The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) zero values will be suppressed.
Note that this suppresses 0s resulting from empty fields and from fields containing 0s.

To control percentage formatting in Word, you need to add a formula and numeric picture switch to the mergefield. To do this:
.. select your mergefield, which will look something like «Percent»;
.. press Ctrl-F9 to wrap another field around it, thus { «Percent» };
.. edit the field so that you get {=«Percent»*100 \# 0.00%};
.. position the cursor anywhere in this field and press F9 to update it.

When you're done, run your mailmerge.

 

[Steve C]

Perfect. Much Thanks!

Hi Steve,

To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this:
.. select the field;
.. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it.

Note: The '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# $,0.00;($,0.00);'-' for currency, with brackets around negative numbers and a hyphen for 0 values


The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) zero values will be suppressed.
Note that this suppresses 0s resulting from empty fields and from fields containing 0s.

To control percentage formatting in Word, you need to add a formula and numeric picture switch to the mergefield. To do this:
.. select your mergefield, which will look something like «Percent»;
.. press Ctrl-F9 to wrap another field around it, thus { «Percent» };
.. edit the field so that you get {=«Percent»*100 \# 0.00%};
.. position the cursor anywhere in this field and press F9 to update it.

When you're done, run your mailmerge.

--
Cheers
macropod
[Microsoft MVP - Word]

Hello,
I'm using the following switch for numeric fields in my mail merge, but i
also need one for currency ($) & percentages (%). Are there switches for
these as well?

{MERGEFIELD "field" \# 0.00 }.

 

[Graham Mayor]

See also http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Perfect. Much Thanks!

Hi Steve,

To control number & currency formatting in Word, add a numeric
picture switch to the mergefield. To do this: .. select the field;
.. press Shift-F9 to reveal the field coding. It should look
something like {MERGEFIELD MyData}; .. edit the field so that you
get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format
you prefer - see below); .. position the cursor anywhere in this
field and press F9 to update it.

Note: The '\# $,0.00' in the field is referred to as a numeric
picture switch. Other possibilities include: .. \# 0 for rounded
whole numbers .. \# ,0 for rounded whole numbers with a thousands
separator .. \# ,0.00 for numbers accurate to two decimal places,
with a thousands separator .. \# $,0 for rounded whole dollars with
a thousands separator .. \# $,0.00;($,0.00);'-' for currency, with
brackets around negative numbers and a hyphen for 0 values


The precision of the displayed value is controlled by the '0.00'.
You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing
following, (eg \# $,0.00;($,0.00) zero values will be suppressed.
Note that this suppresses 0s resulting from empty fields and from
fields containing 0s.

To control percentage formatting in Word, you need to add a formula
and numeric picture switch to the mergefield. To do this: .. select
your mergefield, which will look something like «Percent»; .. press
Ctrl-F9 to wrap another field around it, thus { «Percent» }; .. edit
the field so that you get {=«Percent»*100 \# 0.00%}; .. position the
cursor anywhere in this field and press F9 to update it.

When you're done, run your mailmerge.

--
Cheers
macropod
[Microsoft MVP - Word]

Hello,
I'm using the following switch for numeric fields in my mail merge,
but i also need one for currency ($) & percentages (%). Are there
switches for these as well?

{MERGEFIELD "field" \# 0.00 }.