How do I total each column in a table with mail merge information?

[Noel]

I have a mail merge letter in Word 2003 that pulls information from an Access
database (2003). There are 4 columns: Type, Quarters to Purchase, Cost per
Quarter, and Total Cost. I would like to have a grand total for all the
columns except Type. The information is filled in with mail merge
information. So my question is, how do I total each column with the mail
merge information?

Thanks

 

[Cindy M.]

Hi =?Utf-8?B?Tm9lbA==?=,

I have a mail merge letter in Word 2003 that pulls information from an Access
database (2003). There are 4 columns: Type, Quarters to Purchase, Cost per
Quarter, and Total Cost. I would like to have a grand total for all the
columns except Type. The information is filled in with mail merge
information. So my question is, how do I total each column with the mail
merge information?

Create a Catalog type of mail merge, using a one-row, four-column table
(nothing else in the document). Execute the mail merge to a new document (Step 6
if you're using the Wizard in the task pane) so you can edit the result.

Position the cursor in the last cell of the table and press TAB to create a new
row. Insert the formulas to "Sum above" in the three columns you want to total.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail