calculations in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

2shelbys - 22 Oct 2007 05:58 GMT

Hello,
I need to perform a simple calculation in a mail merge document and I can
not find anything anywhere on how to do it. All I need to do is to multiply a
number from one of the columns in my data file by a number I can input. I
have looked in the tutorial and online and can not find anything. Can someone
please tell me in plain english the easiest way to set up the document to
perform this operation? Your help is most appreciated.

Reply to this Message

Graham Mayor - 22 Oct 2007 07:34 GMT

You need a field calculation using a formula field e.g.

Let's assume that you want to multiply the content of a mergefield called
fieldname by 2 then

{={Mergefield fieldname} * 2}

Both sets of field brackets are entered with CTRL+F9 the remainder is typed.

Obviously the mergefield must have a numeric content.

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hello,
> I need to perform a simple calculation in a mail merge document and I
[quoted text clipped - 4 lines]
> easiest way to set up the document to perform this operation? Your
> help is most appreciated.

Reply to this Message

macropod - 22 Oct 2007 10:50 GMT

Hi 2shelbys,

Taking Graham's response one step further, so that you can do your input, you could insert a FILLIN field into the equation, as in:
{={Mergefield fieldname}*{FILLIN "What value"}}
You can add switches to the FILLIN field to set a default response and to control whether you will be prompted for every record. See
Word's Help file for more details.

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

> Hello,
> I need to perform a simple calculation in a mail merge document and I can
[quoted text clipped - 3 lines]
> please tell me in plain english the easiest way to set up the document to
> perform this operation? Your help is most appreciated.

Reply to this Message

rufus_the_tailgunner - 24 Oct 2007 12:44 GMT

Hi all,
I have a table in a mail merge doc that I want to partly populate with data
at the point of mail-merge and partly with user defined data, which is to be
entered after the the merge takes place. After the user has entered their
data the columns in the table needed to be recalculated to reflect the total.
I tried various strategies - like using ASK fields, REF fields and Bookmarks
- but found that the pop-up boxes for the user-defined data came up
automatically before the user had a chance to look at the merged document.
Currently the method I am adopting is to create some application event
procedures - detailed helpfully in
http://word.mvps.org/FAQs/MacrosVBA/AppClassEvents.htm - so that a series of
Input Boxes pop up when an event occurs, which I'm hoping will be triggered
when the user clicks into the table where my data is held, or as the result
of clicking a command button.
The problem with this approach however is that it involves a bit of VBA
programming so it won't be within everyone's capabilities - it's a shame MS
don't make this kind of event handling a bit easier for general users !

Rufus

> Hi 2shelbys,
>
[quoted text clipped - 11 lines]
> > please tell me in plain english the easiest way to set up the document to
> > perform this operation? Your help is most appreciated.

Reply to this Message