Help!

Calculations Using Word Mail Merge

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> MailMerge Fields RSS
Next:  Office 2K Choosing Contacts  
Author Message
Gingerbread
External


Since: Jul 29, 2007
Posts: 3



PostPosted: Sun Jul 29, 2007 11:12 pm    Post subject: Calculations Using Word Mail Merge
Archived from groups: microsoft>public>word>mailmerge>fields (more info?)

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
Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Mon Jul 30, 2007 6:16 am    Post subject: Re: Calculations Using Word Mail Merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

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

--
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

"Gingerbread" wrote in message

>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
>
Back to top
Gingerbread
External


Since: Jul 29, 2007
Posts: 3



PostPosted: Mon Jul 30, 2007 9:40 pm    Post subject: Re: Calculations Using Word Mail Merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?


"Doug Robbins - Word MVP" wrote:

> Use { = { MERGEFIELD Test1 } + { MERGEFIELD Test2 }}
>
> You must of course use Ctrl+F9 to insert each pair of field delimiters.
>
> --
> 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
>
> "Gingerbread" wrote in message
>
> >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
> >
>
>
>
Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Tue Jul 31, 2007 6:16 am    Post subject: Re: Calculations Using Word Mail Merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.

--
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

"Gingerbread" wrote in message

>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?
>
>
> "Doug Robbins - Word MVP" wrote:
>
>> Use { = { MERGEFIELD Test1 } + { MERGEFIELD Test2 }}
>>
>> You must of course use Ctrl+F9 to insert each pair of field delimiters.
>>
>> --
>> 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
>>
>> "Gingerbread" wrote in message
>>
>> >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
>> >
>>
>>
>>
Back to top
Gingerbread
External


Since: Jul 29, 2007
Posts: 3



PostPosted: Wed Aug 01, 2007 4:50 pm    Post subject: Re: Calculations Using Word Mail Merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you for your assistance, it solved my problem

"Doug Robbins - Word MVP" wrote:

> 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.
>
> --
> 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
>
> "Gingerbread" wrote in message
>
> >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?
> >
> >
> > "Doug Robbins - Word MVP" wrote:
> >
> >> Use { = { MERGEFIELD Test1 } + { MERGEFIELD Test2 }}
> >>
> >> You must of course use Ctrl+F9 to insert each pair of field delimiters.
> >>
> >> --
> >> 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
> >>
> >> "Gingerbread" wrote in message
> >>
> >> >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
> >> >
> >>
> >>
> >>
>
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> MailMerge Fields All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum