Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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.



 
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 09:15 AM


All times are GMT +1. The time now is 09:51 PM.

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"