 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2005How do I sum up 2 fields in Word 2003 Mail Merge?
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 The syntax is { ={ Mergefield Fieldname1 } + { Mergefield Fieldname2 } } where each pair of brackets is set with CTRL+F9  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Dear All, > [quoted text clipped - 4 lines] > > Fuad 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 > The syntax is > { ={ Mergefield Fieldname1 } + { Mergefield Fieldname2 } } [quoted text clipped - 8 lines] > > > > Fuad 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. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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 [quoted text clipped - 24 lines] >>> >>> Fuad 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. > 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 [quoted text clipped - 31 lines] > >>> > >>> Fuad Save yourself all of the trouble and get Excel to add the two values together. SignaturePlease 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 >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 [quoted text clipped - 37 lines] >> >>> >> >>> Fuad 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. > Save yourself all of the trouble and get Excel to add the two values > together. [quoted text clipped - 40 lines] > >> >>> > >> >>> Fuad 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. SignaturePlease 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 >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 [quoted text clipped - 48 lines] >> >> >>> >> >> >>> Fuad Then press F9 to update. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > If you have two mergefields > [quoted text clipped - 86 lines] >>>>>>>> >>>>>>>> Fuad 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. > Then press F9 to update. > [quoted text clipped - 88 lines] > >>>>>>>> > >>>>>>>> Fuad |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.