Reply
 
Thread Tools Display Modes
  #1   Report Post  
XianProf
 
Posts: n/a
Default How do I sum up 2 fields in Word 2003 Mail Merge?

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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Fuad wrote:
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




  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




XianProf wrote:
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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Fuad wrote:
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



  #3   Report Post  
XianProf
 
Posts: n/a
Default

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.

"Graham Mayor" wrote:

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




XianProf wrote:
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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Fuad wrote:
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




  #4   Report Post  
Doug Robbins
 
Posts: n/a
Default

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
"XianProf" wrote in message
...
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.

"Graham Mayor" wrote:

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




XianProf wrote:
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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Fuad wrote:
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






  #5   Report Post  
XianProf
 
Posts: n/a
Default

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.

"Doug Robbins" wrote:

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
"XianProf" wrote in message
...
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.

"Graham Mayor" wrote:

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




XianProf wrote:
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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Fuad wrote:
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








  #6   Report Post  
Doug Robbins
 
Posts: n/a
Default

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
"XianProf" wrote in message
...
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.

"Doug Robbins" wrote:

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
"XianProf" wrote in message
...
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.

"Graham Mayor" wrote:

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




XianProf wrote:
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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Fuad wrote:
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








Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
Mail Merge Final Step in Word 2003 XP blnorwood Mailmerge 2 January 14th 05 06:02 AM
mail merge problem - "Word found locked fields during the update.. zgaryt Tables 1 January 9th 05 01:04 PM
Word 2003 and Access 2003 Mail Merge question HD87glide Microsoft Word Help 2 December 15th 04 02:29 PM
Exchange 2003 - Outlook 2003 - Word 2003 mail merge Micheline Mailmerge 1 December 2nd 04 11:51 AM


All times are GMT +1. The time now is 06:59 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"