Calculations Using Word Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gingerbread - 30 Jul 2007 03:12 GMT

I need to be able to create a mail merge document that adds together several
mail merge fields. The only way that I have been able to do this in the past
is to create a hidden table in which I insert the separate fields and then
sum them. That is no longer working as I need to include more calculations.
What I want to do is to do is something like the following: { MERGEFIELD
Test1 } + { MERGEFIELD Test2 } (note for this example I typed in the braces)

Unfortunately I have to use word for this

I have not found any way of doing this, does anybody know if it is possible

Reply to this Message

Doug Robbins - Word MVP - 30 Jul 2007 05:50 GMT

Use { = { MERGEFIELD Test1 } + { MERGEFIELD Test2 }}

You must of course use Ctrl+F9 to insert each pair of field delimiters.

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 be able to create a mail merge document that adds together
>several
[quoted text clipped - 11 lines]
> I have not found any way of doing this, does anybody know if it is
> possible

Reply to this Message

Gingerbread - 31 Jul 2007 01:40 GMT

I did that but after I have completed the merge, I am left with the following:
{ = 100 + 1 } where Test1 = 100 and Test2 = 1.

The only way that I have been able to chage from the formula to the result
is to click on the formula and press Shift F9. As what I am trying to do is
to include the calculated result on several hundred statements, that option
is not a practical solution. Am I missing something here or is that the way
that it is supposed to work?

> Use { = { MERGEFIELD Test1 } + { MERGEFIELD Test2 }}
>
[quoted text clipped - 15 lines]
> > I have not found any way of doing this, does anybody know if it is
> > possible

Reply to this Message

Doug Robbins - Word MVP - 31 Jul 2007 04:26 GMT

The field may need to be updated after executing the merge. If it is being
executed to a new document, use Ctrl+A to select the whole document and then
use F9 to update the fields. If it is being executed directly to the
Printer, make sure that under Tools>Options>Print, the Update fields box is
checked in the Printing Options section of the dialog.

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 did that but after I have completed the merge, I am left with the
>following:
[quoted text clipped - 31 lines]
>> > I have not found any way of doing this, does anybody know if it is
>> > possible

Reply to this Message

Gingerbread - 01 Aug 2007 20:50 GMT

Thank you for your assistance, it solved my problem

> The field may need to be updated after executing the merge. If it is being
> executed to a new document, use Ctrl+A to select the whole document and then
[quoted text clipped - 37 lines]
> >> > I have not found any way of doing this, does anybody know if it is
> >> > possible

Reply to this Message