Re: How do I sum up 2 fields in Word 2003 Mail Merge?
From: Doug Robbins (dkr_at_NOmvpsSPAM.org)
Date: 02/11/05
- Next message: Doug Robbins: "Re: Select specific excel work*** for mail merge"
- Previous message: Doug Robbins: "Re: How do I add a space in a line if a merge field is blank?"
- In reply to: XianProf: "Re: How do I sum up 2 fields in Word 2003 Mail Merge?"
- Next in thread: XianProf: "Re: How do I sum up 2 fields in Word 2003 Mail Merge?"
- Reply: XianProf: "Re: How do I sum up 2 fields in Word 2003 Mail Merge?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Feb 2005 18:15:06 -0500
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" <XianProf@discussions.microsoft.com> wrote in message news:42B62886-DC2E-4D35-9999-0D76F2F869FE@microsoft.com... >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 >> >> >>
- Next message: Doug Robbins: "Re: Select specific excel work*** for mail merge"
- Previous message: Doug Robbins: "Re: How do I add a space in a line if a merge field is blank?"
- In reply to: XianProf: "Re: How do I sum up 2 fields in Word 2003 Mail Merge?"
- Next in thread: XianProf: "Re: How do I sum up 2 fields in Word 2003 Mail Merge?"
- Reply: XianProf: "Re: How do I sum up 2 fields in Word 2003 Mail Merge?"
- Messages sorted by: [ date ] [ thread ]
Loading