Formula to add merged fields

[Chris]

I use office 97 and am merging excel data to a word
document.
Is there a way I can enter a formula in word to add
individual merge fields from excel rather than adding the
fields in excel and merging that excel result?

 

[Greg Maxey]

Chis,

Do your mean something like { =({MERGEFIELD1}+{MERFIELD2})}?

Sure. Look up formula field in Word help for examples.

 

[Guest]

Yes that is what I mean but I'm not getting a calculated
result.
ie when I enter { =({MERGEFIELD1}+{MERFIELD2})}
I get {=({X}+{Y})}
where X = the value of MERGEFIELD1 1 and
Y = value of MERGEFIELD2

I've put the formula in a text box and in a table with the
same result.

It is probably something simple I'm doing wrong but I'm
baffled

Chris.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

You must use Ctrl+F9 to insert the field delimiters { }

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Guest]

Thanks

I'm now using Ctrl + F9 to insert the field delimiters
{ }. Wuth in these I then entered =( and insert a
mergefield but immediately get the message "!Unexpected
End of Formula".

I also tried up to the point of entering =( after which I
Ctrl + F9 again to insert some more field delimiters to
hold the mergefield but got the same message.

Unfortunately I'm not finding the help very instructive
for this process.

thankyou again for advice on where I'm going wrong

regards

Chris

 

[Peter Jamieson]

What is probably going wrong when you insert the /mergefield/ is that Word
then toggles field code view and evaluates the field, causing the error.
Normally, inserting /all/ the {} using ctrl-F9 does not cause this to
happen. In other words,

ctrl-F9:
{ }
type =(+)
{ ={ }
ctrl-F9 in the correct places:
{ =({ }+{ }) }
type the MERGEFIELD code in
{ =({ MERGEFIELD f1 }+{ MERGEFIELD f2 }) }

If Word does switch view and show a message, you should always be able to
toggle back to field code view using Alt-F9 and continue editing.

Unfortunately I'm not finding the help very instructive
for this process.

No, it isn't.