Mailmerge: writing a final line with a TOTAL field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Helder Costa - 04 Feb 2007 19:51 GMT

I need to create a table in Word, using MailMerge (List type). The data
source is a Excel spreadsheet.
The only fields are "Name" and "Value" like this:
«Name»
«Value»

No problem until this point
But, after list all the records, I need to write a final line with the TOTAL
of the field "Value".
Total......
TOTAL

Is this possible? How?
Thanks for your help.
Hdacosta.

Reply to this Message

Doug Robbins - Word MVP - 05 Feb 2007 04:34 GMT

Easiest to add the row to the Excel Spreadsheet.

In Word, you would have to do it after the merge is complete by adding a row
to the table and then typing in the Total and entering the formula in the
adjacent cell.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I need to create a table in Word, using MailMerge (List type). The data
>source is a Excel spreadsheet.
[quoted text clipped - 11 lines]
> Thanks for your help.
> Hdacosta.

Reply to this Message

Helder Costa - 06 Feb 2007 00:09 GMT

Thank you very much for your help.

I thought there was a way to process that completly automatic.

I think that the best way is to migrating da data source to Access and
process all the mail merge in this application.

Thanks any way!

Hdacosta

> Easiest to add the row to the Excel Spreadsheet.
>
[quoted text clipped - 17 lines]
>> Thanks for your help.
>> Hdacosta.

Reply to this Message