How to do calculation using MERGEFIELD

[EricS]

How do you do calculation on MERGEFIELD ? For example,
add or subtract or multiply several MERGEFIELD and
display the result.

TIA,
Eric.-

 

[Doug Robbins - Word MVP]

Hi Eric,

Not really a vba question. Use the mergefields as components of an = (
formula) field. For example

{ = ({ MERGEFIELD field1 } * { MERGEFIELD field2 } * etc ) }

You must use Ctrl+F9 to insert each pair of { }. Alt+F9 to toggle on and
off the field codes. F9 to update the calculation or do a Print Preview.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[EricS]

Thanks for suggestions. That is exactly what I need to
know. Moreover, I wonder how to create a MERGEFIELD and
refer to this newly created MERGEFIELD to be used in a
calculation somewhere else.

Thanks,
Eric Sulistiawan
Countrywide Home Loans
Simi Valley, CA.