How do I sum up 2 fields in Word 2003 Mail Merge?

F

Fuad

Dear All,

I am trying to sum up two fields in Word Mail Merge, but it seems does not
work. Does anyone have got any idea that can help me.

Thanks

Fuad
 
G

Graham Mayor

The syntax is
{ ={ Mergefield Fieldname1 } + { Mergefield Fieldname2 } }
where each pair of brackets is set with CTRL+F9

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
X

XianProf

I ran into this same issue, but when I used this formula, I got a !Syntax
Error, - field result. To make sure I had the fields typed in properly, I
got rid of just the equal sign, and then the field result gave me my 2
numbers with a plus sign between them (but not the actual sum).

Marc
 
G

Graham Mayor

You still haven't entered the fields correctly. The curly brackets are set
with CTRL+F9 (three pairs) and of course you have to use the field names
from your data file.

If you have two numbers with a plus sign select the lot, press CTRL+F9 to
make the lot into a field and add the = after the first bracket.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
X

XianProf

I checked, and the brackets are ctrl-f9 brackets. The = sign is there as
well. If it helps, I am using Office XP Pro and my data source is an Excel
file.
 
D

Doug Robbins

Save yourself all of the trouble and get Excel to add the two values
together.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 
X

XianProf

I considered that, but then I got to thinking that I SHOULD be able to do
this in Word, and it's always possible I may need this to work in the future,
so I would really like to see this done.
 
D

Doug Robbins

If you have two mergefields

<<Fieldone>> and <<Fieldtwo>>

insert a + sign between them so that you have

<<Fieldone>> + <<Fieldtwo>>

Then select them both and press Ctrl+F9 so that you have

{ <<Fieldone>> + <<Fieldtwo>> }

Then insert an = sign between the { and << so that you have

{ =<<Fieldone>> + <<Fieldtwo>> }

Then press Alt+F9 a couple of times to toggle off the display of the field
codes.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 
G

Graham Mayor

Then press F9 to update.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
X

XianProf

Well, it ends up that I was doing everything correctly in Word (that was
being advised here). On a hunch, I went back to my source file. My data was
formatted by Excel as currency. When I removed the data format in Excel and
reopened my Word doc, a quick F9 gave me the right figures. Apparently,
Word's mail merge can't perform operations on pre-formatted data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top