Adding fields in mail merge

M

Mark

I've tried adding fields using =SUM() and =(mergefield1+
mergefied2). It seems to work in office 2000 but does not
work in Office 2002.

My code looks like this.

{ =SUM({MERGEFIELD "processing_fee"},
{MERGEFIELD "application_fee"}) }

The result of this in the merged document is:

{=SUM(100, 50)}

I've also tried adding the fields:

{=({MERGEFIELD "processing_fee"}+
{MERGEFIELD "application_fee"})}

The result of this in the merged document is:

{= 100+ 50)}

I was expecting 150 as the result. If you can please tell
me what I'm missing?
 
G

Graham Mayor

What you are missing is one of two things
1, You have entered the field boundariess from the keyboard rather using
CTRL+F9
or
2. You need to toggle the resulting field to display the result - ALT+F9
or maybe both :)

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 

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