Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I total data brought in from an external data source?
I have a document that includes merge data (in the form of dollar amounts) in
fields which are in a table. I would like to total those dollar amounts at the bottom of the table. I tried using the sum function, but could not get the formula function to recognize the merge fields. Is this possible to do? And if so, how? Thanks, Nick. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I total data brought in from an external data source?
Use the following type of field construction
{ = { MERGFIELD Field1name } + { MERGEFIELD Field2Name } + ....... } -- 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 "Nick Manley" Nick wrote in message ... I have a document that includes merge data (in the form of dollar amounts) in fields which are in a table. I would like to total those dollar amounts at the bottom of the table. I tried using the sum function, but could not get the formula function to recognize the merge fields. Is this possible to do? And if so, how? Thanks, Nick. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I total data brought in from an external data source?
Thank you, Doug! I'll give it a shot. Am I removing the { in your formula, or
are the mergefield fieldnames bracketed like that in the formula? Thanks, Nick. "Doug Robbins - Word MVP" wrote: Use the following type of field construction { = { MERGFIELD Field1name } + { MERGEFIELD Field2Name } + ....... } -- 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 "Nick Manley" Nick wrote in message ... I have a document that includes merge data (in the form of dollar amounts) in fields which are in a table. I would like to total those dollar amounts at the bottom of the table. I tried using the sum function, but could not get the formula function to recognize the merge fields. Is this possible to do? And if so, how? Thanks, Nick. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I total data brought in from an external data source?
The brackets indicate fields - in this case your mergefields. If you are
assembling fields from the keyboard rather than inserting them, you create each pair of brackets with CTRL+F9. Change the fieldnames to those in your data file. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Nick Manley wrote: Thank you, Doug! I'll give it a shot. Am I removing the { in your formula, or are the mergefield fieldnames bracketed like that in the formula? Thanks, Nick. "Doug Robbins - Word MVP" wrote: Use the following type of field construction { = { MERGFIELD Field1name } + { MERGEFIELD Field2Name } + ....... } -- 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 "Nick Manley" Nick wrote in message ... I have a document that includes merge data (in the form of dollar amounts) in fields which are in a table. I would like to total those dollar amounts at the bottom of the table. I tried using the sum function, but could not get the formula function to recognize the merge fields. Is this possible to do? And if so, how? Thanks, Nick. |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I total data brought in from an external data source?
Hi Graham,
Thank you for the response. When I use the following formula I get a Syntax error: ={MERGEFIELDMembership_Dues_Amount}+{MERGEFIELDDiv ision_Dues_Amount_Membership}+{MERGEFIELDStandards }+{MERGEFIELDISA_Transactions}+{MERGEFIELDAirmail} +{MERGEFIELDDonations} I did not create this document or insert the fields. They were there when I got it and I was asked if they can be totaled in a seperate cell in the table (each field has its own cell). Currently the merge fields are bracketed with a and . "Graham Mayor" wrote: The brackets indicate fields - in this case your mergefields. If you are assembling fields from the keyboard rather than inserting them, you create each pair of brackets with CTRL+F9. Change the fieldnames to those in your data file. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Nick Manley wrote: Thank you, Doug! I'll give it a shot. Am I removing the { in your formula, or are the mergefield fieldnames bracketed like that in the formula? Thanks, Nick. "Doug Robbins - Word MVP" wrote: Use the following type of field construction { = { MERGFIELD Field1name } + { MERGEFIELD Field2Name } + ....... } -- 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 "Nick Manley" Nick wrote in message ... I have a document that includes merge data (in the form of dollar amounts) in fields which are in a table. I would like to total those dollar amounts at the bottom of the table. I tried using the sum function, but could not get the formula function to recognize the merge fields. Is this possible to do? And if so, how? Thanks, Nick. |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I total data brought in from an external data source?
You need another bracket around the calculation and spaces between
Mergefield and the field names {={MERGEFIELD Membership_Dues_Amount} + {MERGEFIELD Division_Dues_Amount_Membership} + {MERGEFIELD Standards} + {MERGEFIELD ISA_Transactions} + {MERGEFIELD Airmail} + {MERGEFIELD Donations}} Use ALT + F9 to toggle between (say) {MERGEFIELD Membership_Dues_Amount} and Membership_Dues_Amount -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Nick Manley wrote: Hi Graham, Thank you for the response. When I use the following formula I get a Syntax error: I did not create this document or insert the fields. They were there when I got it and I was asked if they can be totaled in a seperate cell in the table (each field has its own cell). Currently the merge fields are bracketed with a and . "Graham Mayor" wrote: The brackets indicate fields - in this case your mergefields. If you are assembling fields from the keyboard rather than inserting them, you create each pair of brackets with CTRL+F9. Change the fieldnames to those in your data file. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Nick Manley wrote: Thank you, Doug! I'll give it a shot. Am I removing the { in your formula, or are the mergefield fieldnames bracketed like that in the formula? Thanks, Nick. "Doug Robbins - Word MVP" wrote: Use the following type of field construction { = { MERGFIELD Field1name } + { MERGEFIELD Field2Name } + ....... } -- 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 "Nick Manley" Nick wrote in message ... I have a document that includes merge data (in the form of dollar amounts) in fields which are in a table. I would like to total those dollar amounts at the bottom of the table. I tried using the sum function, but could not get the formula function to recognize the merge fields. Is this possible to do? And if so, how? Thanks, Nick. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
get external data source from excel | Mailmerge | |||
How can I add data fields to a data source in Word Mail Merge? | Mailmerge | |||
data form button greyed out in word 97 data source | Mailmerge | |||
data in mail merge letter being cut off - data source field size? | Mailmerge | |||
Merged data that is present in data source is missing in merge | Mailmerge |