Summary
Microsoft Word has a feature that allows users to do calculations based on mail merge fields.
1
This can be done by creating an expression field and adding the formula field.
1
Additionally, conditional fields can be used to make decisions about the data and to make the most of the mail merge.
2
Furthermore, users can use a field coded as "= "Field1" + "Field2" to create the field and add numeric formatting switches.
3
Finally, IF fields can be used to make mail merges more intelligent by suppressing unwanted spaces and commas in an address, inserting different boilerplate files depending on certain conditions, and inserting a "his" or "her" name depending on gender.
4
According to
See more results on Neeva
Summaries from the best pages on the web
Summary
One of the little known features of Microsoft Word is the ability to do calculations based on mail merge fields.
The process is as easy as creating an expression field and adding the formula field but somewhat hidden from the normal options Word gives you for using the mail merge fields.
Word 2010 – Calculations using mail merge fields – IT Support Guides
itsupportguides.com
Summary
This article provides instructions on how to use conditional fields in a Word mail merge to clarify data and make decisions. It explains how to set up the mail merge, map Word placeholders to Excel fields, and insert an IF field to handle membership types. It also provides tips on how to use conditional fields to make decisions about the data and how to use them to make the most of the mail merge.
How to use conditional fields in a Word mail merge | TechRepublic
techrepublic.com
Summary
Microsoft Community users are trying to create a Word document that pulls two mail merge fields onto the document and calculates the two fields to give a total of the two mailmerge fields. However, when the document is produced, an error message appears saying "Error! Bookmark not defined." The user can use a field coded as "= "Field1" + "Field2" to create the field, and can add numeric formatting switches as described at the Microsoft Office Forums.
Sum of 2 mail merge fields - Microsoft Community
microsoft.com
Unable to generate a short snippet for this page, sorry about that.
pacificu.edu
Summary
IF fields can be used to make mail merges more intelligent by suppressing unwanted spaces and commas in an address, inserting different boilerplate files depending on certain conditions, and inserting a "his" or "her" name depending on gender. IF fields can be used to insert different series of boilerplate files depending on certain conditions stored in the data file, and can be used to insert different series of boilerplate files depending on certain conditions.
Making your mail merge “intelligent” by using IF fields
wordmvp.com
Leverage Microsoft Word’s calculation fields for simple calculations in Word templates. ... Then you must nest your merge fields inside of your formula: { ...
Creating Word Calculation Fields
conga.com
This tutorial explains how to do a mail merge from Excel to Word step-by-step. See how to ... at 5:51 pm how do I mail merge a cell which contains the formula ...
How to mail merge from Excel to Word
ablebits.com
