Merge fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 02 Aug 2006 18:42 GMT

I have two problems:

I want to add together two merge fields. I am using the insert equation in a
table. The format I am using is: {={MAILMERGEopeningbid}+{MAILMERGEincrement}}
This keeps giving me a syntax error.

The next thing I want to do I add together in a cell the result of the new
field I am calculating above plus the MERGEFIELD increment.

Can one of you really smart people tell me how to do this?

Reply to this Message

Peter Jamieson - 02 Aug 2006 21:21 GMT

You need

{ ={ MERGEFIELD openingbid }+{ MERGEFIELD increment } }

(i.e. MERGEFIELD not MAILMERGE, and a space after MERGEFIELD)

All the {} need to be the special field braces you can insert using ctrl-F9.

If the field names have spaces in them, e.g. if it is not "openingbid" but
"opening bid", you have to quote them, e.g. { MERGEFIELD "opening bid" }

> The next thing I want to do I add together in a cell the result of the new
> field I am calculating above plus the MERGEFIELD increment.

That sounds like

{ ={ MERGEFIELD openingbid }+{ MERGEFIELD increment }+{ MERGEFIELD
increment }}

but I'm not convinced I've understood.

Peter Jamieson

>I have two problems:
>
[quoted text clipped - 8 lines]
>
> Can one of you really smart people tell me how to do this?

Reply to this Message