Word 2000 Mail Merge with Formula?

[smurfer]

Is it possible to use a sum formula for a data field with word 2000 mail merge? I have 3 data entry fields that I am using with a mail merge feature (using word as data source as well), but I want field 4 to calculate and auto populate the sum of fields 1,2,and 3. Is this possible? If so, can you advise how it is done? It needs to be done in word or possibly excel if but preference is word..As it stand I only can get 4 to be manually edited, no formula capability.
Thanks,
SM

 

[ilses]

Well, yes. It is possible by inserting a Formula field and not typing a formula. Switch to see the field code, insert the first merge field, type + (plus sign), etc.
You'd end up with something like:
<<AmountA>> plus <<AmountB>> equals {= {MERGEFIELD AmountA} + {MERGEFIELD AmountB} \* MERGEFORMAT}.
You may at first see two amounts displayed, rightclick to display the field codes for these inserted fields.
I have not tested what happens if the merge fields are the results of ASK or FILLIN fields.

IS