Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
2shelbys 2shelbys is offline
external usenet poster
 
Posts: 1
Default calculations in mail merge

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.

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default calculations in mail merge

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

--

Graham Mayor - Word MVP

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



2shelbys wrote:
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.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default calculations in mail merge

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
--
macropod
[MVP - Microsoft Word]
-------------------------

"2shelbys" wrote in message ...
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.


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
rufus_the_tailgunner rufus_the_tailgunner is offline
external usenet poster
 
Posts: 1
Default calculations in mail merge

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

"macropod" wrote:

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
--
macropod
[MVP - Microsoft Word]
-------------------------

"2shelbys" wrote in message ...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Perform mathematical calculations with merge fields cjlatta Mailmerge 14 May 17th 23 02:49 PM
Calculations Using Word Mail Merge Gingerbread Mailmerge 4 August 1st 07 08:50 PM
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? gmax2006 Microsoft Word Help 1 March 28th 07 06:28 PM
Date Calculations in Word Mail Merge Noah Kaufman Mailmerge 4 October 14th 06 12:32 PM
mail merge doc with further linked/embedded mail merge docs not playing the game Rob Cowlard Mailmerge 3 January 8th 05 10:15 AM


All times are GMT +1. The time now is 02:46 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"