Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
Two queries
1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e £105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
See http://www.gmayor.com/insert_a_date_...than_today.htm and in
particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e 105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
Sorry could you help me further. I set the word document with a bookmark
named "Payment" it set up to ask me for an amount, for eample £102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? £ 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0{y\*Cardtext} Pound}{IF{y}1 s}{IF{y}0{IF{z}0 and } }{IF{z}0 {z \*Cardtext} pence{IF{z}1 s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e £105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
{ Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) *
100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not 102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample 102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e 105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
I think the problem is i have used ASK field or FILL-IN Field so it is taking
the 102.53 as text not numbers? could this be the case if so is there a way around this i want the mail merge to promt me to fill in a number? "Graham Mayor" wrote: { Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not £102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample £102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? £ 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e £105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
{ Ask Amount Amount? }{ Set x { Amount }}{ Set y { =INT({ x }) } }{ Set z
{ =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } At the prompt enter 102.53 or whatever. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: I think the problem is i have used ASK field or FILL-IN Field so it is taking the 102.53 as text not numbers? could this be the case if so is there a way around this i want the mail merge to promt me to fill in a number? "Graham Mayor" wrote: { Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not 102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample 102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e 105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
When put in the if formula's i comes up with a !Syntax Error, ) is this
because I don't have the neccessary add-ins? "Graham Mayor" wrote: { Ask Amount Amount? }{ Set x { Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } At the prompt enter 102.53 or whatever. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: I think the problem is i have used ASK field or FILL-IN Field so it is taking the 102.53 as text not numbers? could this be the case if so is there a way around this i want the mail merge to promt me to fill in a number? "Graham Mayor" wrote: { Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not £102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample £102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? £ 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e £105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
please ignore my message re Syntax it was because i have an = sign in the
formula in front of IF. But on the mail merge there is no text or number and on a separate document it returns this message, any ideas? "A field calculation error occurred in record 1." "Graham Mayor" wrote: { Ask Amount Amount? }{ Set x { Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } At the prompt enter 102.53 or whatever. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: I think the problem is i have used ASK field or FILL-IN Field so it is taking the 102.53 as text not numbers? could this be the case if so is there a way around this i want the mail merge to promt me to fill in a number? "Graham Mayor" wrote: { Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not £102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample £102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? £ 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e £105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
There are no add-ins required. You have the syntax error because you made a
mistake copying the formulae - easy to do, but unfortunately fields cannot be simply copied and pasted. The error message points to an erroneous bracket. Each pair of curly brackets {} is created with CTRL+F9. There are round brackets in the calculated fields. The spacing is important also. There is also a missing quote (though it will not stop the field working) { IF { z } 0 "{ z \*Cardtext \*Caps }" pence -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: When put in the if formula's i comes up with a !Syntax Error, ) is this because I don't have the neccessary add-ins? "Graham Mayor" wrote: { Ask Amount Amount? }{ Set x { Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } At the prompt enter 102.53 or whatever. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: I think the problem is i have used ASK field or FILL-IN Field so it is taking the 102.53 as text not numbers? could this be the case if so is there a way around this i want the mail merge to promt me to fill in a number? "Graham Mayor" wrote: { Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not 102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample 102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e 105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
You have now lost me. If you are getting the information from a merge field
then why do you need the ask/fillin field? For mnail merge you need { Set x {Mergefield Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } where Amount is the fieldname of the number you want as text. It won't work if the field contains anything other than a number. If you have a pound sign in the field change that to {Mergefield Amount \# 0.00} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: please ignore my message re Syntax it was because i have an = sign in the formula in front of IF. But on the mail merge there is no text or number and on a separate document it returns this message, any ideas? "A field calculation error occurred in record 1." "Graham Mayor" wrote: { Ask Amount Amount? }{ Set x { Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } At the prompt enter 102.53 or whatever. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: I think the problem is i have used ASK field or FILL-IN Field so it is taking the 102.53 as text not numbers? could this be the case if so is there a way around this i want the mail merge to promt me to fill in a number? "Graham Mayor" wrote: { Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not 102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample 102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e 105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#11
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
Sorry for the confusion, it is a document which as some mergefields as well
as fillins and ask, the one I need your help on is not a mergefield. I want the document to ask me for an amount? I then enter say 102.53 it then puts the figures in as £102.53 along with the words "One Hundred and Two Pounds and Fifty Three Pence". Using the code you gave me it does not show any numbers or text I can get it to show numbers if i use REF Amount But the error message "field calculation error occured in record 1" must relate to your fields as when i remove it the document works fine Any ideas? "Graham Mayor" wrote: You have now lost me. If you are getting the information from a merge field then why do you need the ask/fillin field? For mnail merge you need { Set x {Mergefield Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } where Amount is the fieldname of the number you want as text. It won't work if the field contains anything other than a number. If you have a pound sign in the field change that to {Mergefield Amount \# 0.00} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: please ignore my message re Syntax it was because i have an = sign in the formula in front of IF. But on the mail merge there is no text or number and on a separate document it returns this message, any ideas? "A field calculation error occurred in record 1." "Graham Mayor" wrote: { Ask Amount Amount? }{ Set x { Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } At the prompt enter 102.53 or whatever. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: I think the problem is i have used ASK field or FILL-IN Field so it is taking the 102.53 as text not numbers? could this be the case if so is there a way around this i want the mail merge to promt me to fill in a number? "Graham Mayor" wrote: { Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not £102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample £102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? £ 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e £105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#12
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
I have changed the name of the bookmark in case it clashes with a fieldname
your data file. The REF field {oAmount \# ",0.00"} will display the sign. The rest displays the words. { Ask oAmount Amount? }{oAmount \# ",0.00"} { Set x { oAmount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } If this doesn't work send me the merge document and a small data sample to the link on the home page of my web site and I'll see if I can spot the problem -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry for the confusion, it is a document which as some mergefields as well as fillins and ask, the one I need your help on is not a mergefield. I want the document to ask me for an amount? I then enter say 102.53 it then puts the figures in as 102.53 along with the words "One Hundred and Two Pounds and Fifty Three Pence". Using the code you gave me it does not show any numbers or text I can get it to show numbers if i use REF Amount But the error message "field calculation error occured in record 1" must relate to your fields as when i remove it the document works fine Any ideas? "Graham Mayor" wrote: You have now lost me. If you are getting the information from a merge field then why do you need the ask/fillin field? For mnail merge you need { Set x {Mergefield Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } where Amount is the fieldname of the number you want as text. It won't work if the field contains anything other than a number. If you have a pound sign in the field change that to {Mergefield Amount \# 0.00} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: please ignore my message re Syntax it was because i have an = sign in the formula in front of IF. But on the mail merge there is no text or number and on a separate document it returns this message, any ideas? "A field calculation error occurred in record 1." "Graham Mayor" wrote: { Ask Amount Amount? }{ Set x { Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } At the prompt enter 102.53 or whatever. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: I think the problem is i have used ASK field or FILL-IN Field so it is taking the 102.53 as text not numbers? could this be the case if so is there a way around this i want the mail merge to promt me to fill in a number? "Graham Mayor" wrote: { Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not 102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample 102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e 105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#13
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
Sorry i couldn't find the link on you website, i thought i'd give this one
more go I really appreciate you trying to help me Just to summaries how i have tried to create the fields, After pressing ctrl + F9 i have tried simply typing in the fields and also tried by right clicking in the field to edit it and using the various options such as formulas, ASK , REF, SET etc within word, not sure if either approaches are correct but neither has worked. I have retyped here the fields i have set up. { ASK oAmount Amount? \o }{ REF oAmount \# "£,0.00" }{ SET x { oAmount } } { SET y { = INT({ x }) } }{ SET z { =({ x }) - ({ y }) * 100 } }{ IF{ y } 0 "{ y \* Cardtext \* Caps } Pound" }{IF{ y } 1 "s" }{ IF{ y } 0 "{ IF{ z } 0 " and " " " } " }{ IF{ z } 0 "{ z \*Cardtext \*Caps }" Pence } } I think there must be something wrong with the "formulas" i have set up as every time i create a new document it prompts me for the value i enter 152.30 it then generates the document showing the value £152.30 but no words!!, another word dcoument is then open after the merge process and this says "field calculation error occured in record 1" Any ideas what to do next "Graham Mayor" wrote: I have changed the name of the bookmark in case it clashes with a fieldname your data file. The REF field {oAmount \# "£,0.00"} will display the £ sign. The rest displays the words. { Ask oAmount Amount? }{oAmount \# "£,0.00"} { Set x { oAmount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } If this doesn't work send me the merge document and a small data sample to the link on the home page of my web site and I'll see if I can spot the problem -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry for the confusion, it is a document which as some mergefields as well as fillins and ask, the one I need your help on is not a mergefield. I want the document to ask me for an amount? I then enter say 102.53 it then puts the figures in as £102.53 along with the words "One Hundred and Two Pounds and Fifty Three Pence". Using the code you gave me it does not show any numbers or text I can get it to show numbers if i use REF Amount But the error message "field calculation error occured in record 1" must relate to your fields as when i remove it the document works fine Any ideas? "Graham Mayor" wrote: You have now lost me. If you are getting the information from a merge field then why do you need the ask/fillin field? For mnail merge you need { Set x {Mergefield Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } where Amount is the fieldname of the number you want as text. It won't work if the field contains anything other than a number. If you have a pound sign in the field change that to {Mergefield Amount \# 0.00} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: please ignore my message re Syntax it was because i have an = sign in the formula in front of IF. But on the mail merge there is no text or number and on a separate document it returns this message, any ideas? "A field calculation error occurred in record 1." "Graham Mayor" wrote: { Ask Amount Amount? }{ Set x { Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } At the prompt enter 102.53 or whatever. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: I think the problem is i have used ASK field or FILL-IN Field so it is taking the 102.53 as text not numbers? could this be the case if so is there a way around this i want the mail merge to promt me to fill in a number? "Graham Mayor" wrote: { Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not £102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample £102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? £ 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e £105.25 to One Hundred and Five Pounds and Twenty Five Pence |
#14
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Future merge field dates
The link is on the home page of my web site www.gmayor.com
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry i couldn't find the link on you website, i thought i'd give this one more go I really appreciate you trying to help me Just to summaries how i have tried to create the fields, After pressing ctrl + F9 i have tried simply typing in the fields and also tried by right clicking in the field to edit it and using the various options such as formulas, ASK , REF, SET etc within word, not sure if either approaches are correct but neither has worked. I have retyped here the fields i have set up. { ASK oAmount Amount? \o }{ REF oAmount \# ",0.00" }{ SET x { oAmount } } { SET y { = INT({ x }) } }{ SET z { =({ x }) - ({ y }) * 100 } }{ IF{ y } 0 "{ y \* Cardtext \* Caps } Pound" }{IF{ y } 1 "s" }{ IF{ y } 0 "{ IF{ z } 0 " and " " " } " }{ IF{ z } 0 "{ z \*Cardtext \*Caps }" Pence } } I think there must be something wrong with the "formulas" i have set up as every time i create a new document it prompts me for the value i enter 152.30 it then generates the document showing the value 152.30 but no words!!, another word dcoument is then open after the merge process and this says "field calculation error occured in record 1" Any ideas what to do next "Graham Mayor" wrote: I have changed the name of the bookmark in case it clashes with a fieldname your data file. The REF field {oAmount \# ",0.00"} will display the sign. The rest displays the words. { Ask oAmount Amount? }{oAmount \# ",0.00"} { Set x { oAmount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } If this doesn't work send me the merge document and a small data sample to the link on the home page of my web site and I'll see if I can spot the problem -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry for the confusion, it is a document which as some mergefields as well as fillins and ask, the one I need your help on is not a mergefield. I want the document to ask me for an amount? I then enter say 102.53 it then puts the figures in as 102.53 along with the words "One Hundred and Two Pounds and Fifty Three Pence". Using the code you gave me it does not show any numbers or text I can get it to show numbers if i use REF Amount But the error message "field calculation error occured in record 1" must relate to your fields as when i remove it the document works fine Any ideas? "Graham Mayor" wrote: You have now lost me. If you are getting the information from a merge field then why do you need the ask/fillin field? For mnail merge you need { Set x {Mergefield Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } where Amount is the fieldname of the number you want as text. It won't work if the field contains anything other than a number. If you have a pound sign in the field change that to {Mergefield Amount \# 0.00} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: please ignore my message re Syntax it was because i have an = sign in the formula in front of IF. But on the mail merge there is no text or number and on a separate document it returns this message, any ideas? "A field calculation error occurred in record 1." "Graham Mayor" wrote: { Ask Amount Amount? }{ Set x { Amount }}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } At the prompt enter 102.53 or whatever. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: I think the problem is i have used ASK field or FILL-IN Field so it is taking the 102.53 as text not numbers? could this be the case if so is there a way around this i want the mail merge to promt me to fill in a number? "Graham Mayor" wrote: { Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } (watch the spaces and don't use smart quotes) should work. Don't forget each pair of brackets {} is placed with CTRL+F9 If the bookmark Payment contains only a number ie 102.53 and not 102.53 then { Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Sorry could you help me further. I set the word document with a bookmark named "Payment" it set up to ask me for an amount, for eample 102.53, I then tried to use your previous link to convert into words but I couldn't get it to work Are the x,y,z letters default or is this something i need to set up in another field?? 102.53 {SET x 102.53}{SET y { =INT({x})}}{SET z { =({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1 "s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext} pence"{IF{z}1 "s "Graham Mayor" wrote: See http://www.gmayor.com/insert_a_date_...than_today.htm and in particular the link to Macropod's downloadable document. For the cash to text see http://www.gmayor.com/formatting_word_fields.htm and the section - Formatting cash amounts in words -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Craig wrote: Two queries 1) I need to create a furture date in word that is linked to a merge field. E.g the merge field i have creates a date, say, 28 February 2009 i then want to create a future date that is 9 months in the future but the last day of that month i.e 30 November 2009. I also want to create a future date which is 9 months and one day, is this possible to do using fields? 2) i need to convert number in to text using merge formating i.e 105.25 to One Hundred and Five Pounds and Twenty Five Pence |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Future Dates - Again! | Mailmerge | |||
Can Word automatically send reminders on specific future dates? | Microsoft Word Help | |||
Entering fields for future dates? | Microsoft Word Help | |||
How to calculate Future Dates? | Microsoft Word Help | |||
Merge field to add tomorrow's (or other future) date | New Users |