I'm making a mail merge Directory and have got it pretty much doing what it's supposed to. This tutorial was invaluable: http://windowssecrets.com/forums/sho...merge-Tutorial

I have a list of sales figures in the directory, and I can successfully add up the totals per salesperson but only if the total appears below the table of repeated data.

For example, I would like the letter to read:



Congratulations Josh! This month your totals were $3,500. Here are the details of your transactions:

7/7/13 $1,000
7/8/13 $2,000
7/9/13 $500

Again, I can total those numbers if the total appears below, but I can't display a total above. In my letters the above total appears as $0.

Any ideas how I can do this? Thanks!

Our Database Manager solved my problems. He included the calulation in the extract to Excel, so I don't have to do any calculations in Word. I like a good riddle, but it seems like Word fails when trying to display a calculation from a mail merge directory above the numbers. Oh well.

Hi Beeblebrox,

It might be possible to do what you're after via some additional field coding, but it'd be a fair bit of effort for something there has been little call for and for which it appears you already have a solution.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yes, the solution was to not do the calculation in Word. When our DBA extracted the data to Excel he performed the calculation there. All Word had to do was bring it in as a regular field.