Formula to add merged fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 23 Jan 2004 04:14 GMT

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?

Reply to this Message

Greg Maxey - 23 Jan 2004 04:29 GMT

Chis,

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

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

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org

> 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?

Reply to this Message

- 23 Jan 2004 05:50 GMT

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.

>-----Original Message-----
>Chis,
[quoted text clipped - 10 lines]
>
>.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 23 Jan 2004 08:41 GMT

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

Signature

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

> Yes that is what I mean but I'm not getting a calculated
> result.
[quoted text clipped - 29 lines]
>>
>>.

Reply to this Message

- 28 Jan 2004 01:55 GMT

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

>-----Original Message-----
>You must use Ctrl+F9 to insert the field delimiters { }
[quoted text clipped - 34 lines]
>
>.

Reply to this Message

Peter Jamieson - 28 Jan 2004 10:03 GMT

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.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Thanks
>
[quoted text clipped - 68 lines]
> >
> >.

Reply to this Message