Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MS Word 2003 Formatting merged fields
Another program has the abitlity to merge its database fields into a Word
template. The resulting merged document results in all currency fields having no dollar sign nor commas. The template field directly from the database would be - Additional Amt resulting in - 15000.00 The underlying field code is - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \* MERGEFORMAT } If I try to add formatting to it as in - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \# ###.00 \* MERGEFORMAT } It results in - Additional Amt as text in the document. I just need to get the fields formatted correctly, when pulling them into the template. Thanks for any help. -- Gus Evans |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MS Word 2003 Formatting merged fields
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm It may be necessary to turn it into a formula { = 1 * { DOCVARIABLE etc } \# "$,0/00" } -- 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 "GusEvans" wrote in message news Another program has the abitlity to merge its database fields into a Word template. The resulting merged document results in all currency fields having no dollar sign nor commas. The template field directly from the database would be - Additional Amt resulting in - 15000.00 The underlying field code is - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \* MERGEFORMAT } If I try to add formatting to it as in - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \# ###.00 \* MERGEFORMAT } It results in - Additional Amt as text in the document. I just need to get the fields formatted correctly, when pulling them into the template. Thanks for any help. -- Gus Evans |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MS Word 2003 Formatting merged fields
Gus: Try your formula as you have it but enclose the formatting in " " (
after the LAST #. J Nelson. "GusEvans" wrote: Another program has the abitlity to merge its database fields into a Word template. The resulting merged document results in all currency fields having no dollar sign nor commas. The template field directly from the database would be - Additional Amt resulting in - 15000.00 The underlying field code is - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \* MERGEFORMAT } If I try to add formatting to it as in - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \# ###.00 \* MERGEFORMAT } It results in - Additional Amt as text in the document. I just need to get the fields formatted correctly, when pulling them into the template. Thanks for any help. -- Gus Evans |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MS Word 2003 Formatting merged fields
I hope you don't mind my popping into your post, even though it has nothing
to do with what I'm looking for. I am going nuts and have no way of finding this info... on a try-it version of word 2007 (that just pops up via something called citrex and doesn't need downloading ) I found a command on the toolbar the enclose text. In this version, it appears as an icon on the font toolbar as a circle with something in it. I have since downloaded the trial of word 07 (to see if I Like it) before buying it, and no 'enclose text' command can be found anywhere... there is no way to add it to the tool bar, and the circle-like icon doesn't exist anywhere. How do I find which version has that, since I can use if a lot... or whether my trial version has it and I'm just missing it somewhere (which I doubt). I already looked at the 'character map' but there is nothing that circles words, or encloses text. I thank you for reading this... I have tried to find a way to email support before purchasing; I have checked the knowledge base and put a search out there all over the place... How the heck do I circle a word or letter in word 2007? I can't find this information anywhere. Google is no longer my friend. If you can help, thanks a lot. If you can't and can direct me elsewhere, I would appreciate that. "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm It may be necessary to turn it into a formula { = 1 * { DOCVARIABLE etc } \# "$,0/00" } -- 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 "GusEvans" wrote in message news Another program has the abitlity to merge its database fields into a Word template. The resulting merged document results in all currency fields having no dollar sign nor commas. The template field directly from the database would be - Additional Amt resulting in - 15000.00 The underlying field code is - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \* MERGEFORMAT } If I try to add formatting to it as in - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \# ###.00 \* MERGEFORMAT } It results in - Additional Amt as text in the document. I just need to get the fields formatted correctly, when pulling them into the template. Thanks for any help. -- Gus Evans |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MS Word 2003 Formatting merged fields
Have a look for Windows Start|"All Programs"|"Microsoft Office"|"Microsoft
Office Tools"|"Microsoft Office 2007 Language Settings" (or something like that) and enable one of the East Asian languages, e.g. Japanesee, Korean, Simplified Chinese or Traditional Chinese. At least I think that's what you need. When Word restarts, you should see a number of additional facilities (although I can't tell youu where you will find them in the Word Ribbon). Just bear in mind that anyone who hasn't also enabled one of these languages may find they can't edit what you have produced. Peter Jamieson "imateacher" wrote in message ... I hope you don't mind my popping into your post, even though it has nothing to do with what I'm looking for. I am going nuts and have no way of finding this info... on a try-it version of word 2007 (that just pops up via something called citrex and doesn't need downloading ) I found a command on the toolbar the enclose text. In this version, it appears as an icon on the font toolbar as a circle with something in it. I have since downloaded the trial of word 07 (to see if I Like it) before buying it, and no 'enclose text' command can be found anywhere... there is no way to add it to the tool bar, and the circle-like icon doesn't exist anywhere. How do I find which version has that, since I can use if a lot... or whether my trial version has it and I'm just missing it somewhere (which I doubt). I already looked at the 'character map' but there is nothing that circles words, or encloses text. I thank you for reading this... I have tried to find a way to email support before purchasing; I have checked the knowledge base and put a search out there all over the place... How the heck do I circle a word or letter in word 2007? I can't find this information anywhere. Google is no longer my friend. If you can help, thanks a lot. If you can't and can direct me elsewhere, I would appreciate that. "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm It may be necessary to turn it into a formula { = 1 * { DOCVARIABLE etc } \# "$,0/00" } -- 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 "GusEvans" wrote in message news Another program has the abitlity to merge its database fields into a Word template. The resulting merged document results in all currency fields having no dollar sign nor commas. The template field directly from the database would be - Additional Amt resulting in - 15000.00 The underlying field code is - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \* MERGEFORMAT } If I try to add formatting to it as in - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \# ###.00 \* MERGEFORMAT } It results in - Additional Amt as text in the document. I just need to get the fields formatted correctly, when pulling them into the template. Thanks for any help. -- Gus Evans |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MS Word 2003 Formatting merged fields
It probably appeared on the Font chunk in that version because Asian
Language Support was enabled. You can add it to the Quick Access Toolbar by clicking on the Office Button and then click on the Word Options at the bottom of the dialog and then on Customize and select All Commands in the Choose commands from pulldown and then scroll down through the list until you come to Enclose Characters and then click on the Add button. -- 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 "imateacher" wrote in message ... I hope you don't mind my popping into your post, even though it has nothing to do with what I'm looking for. I am going nuts and have no way of finding this info... on a try-it version of word 2007 (that just pops up via something called citrex and doesn't need downloading ) I found a command on the toolbar the enclose text. In this version, it appears as an icon on the font toolbar as a circle with something in it. I have since downloaded the trial of word 07 (to see if I Like it) before buying it, and no 'enclose text' command can be found anywhere... there is no way to add it to the tool bar, and the circle-like icon doesn't exist anywhere. How do I find which version has that, since I can use if a lot... or whether my trial version has it and I'm just missing it somewhere (which I doubt). I already looked at the 'character map' but there is nothing that circles words, or encloses text. I thank you for reading this... I have tried to find a way to email support before purchasing; I have checked the knowledge base and put a search out there all over the place... How the heck do I circle a word or letter in word 2007? I can't find this information anywhere. Google is no longer my friend. If you can help, thanks a lot. If you can't and can direct me elsewhere, I would appreciate that. "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm It may be necessary to turn it into a formula { = 1 * { DOCVARIABLE etc } \# "$,0/00" } -- 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 "GusEvans" wrote in message news Another program has the abitlity to merge its database fields into a Word template. The resulting merged document results in all currency fields having no dollar sign nor commas. The template field directly from the database would be - Additional Amt resulting in - 15000.00 The underlying field code is - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \* MERGEFORMAT } If I try to add formatting to it as in - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \# ###.00 \* MERGEFORMAT } It results in - Additional Amt as text in the document. I just need to get the fields formatted correctly, when pulling them into the template. Thanks for any help. -- Gus Evans |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MS Word 2003 Formatting merged fields
Yes! It worked. Something so simple as 'all commands!' Thanks so very much.
"Doug Robbins - Word MVP" wrote: It probably appeared on the Font chunk in that version because Asian Language Support was enabled. You can add it to the Quick Access Toolbar by clicking on the Office Button and then click on the Word Options at the bottom of the dialog and then on Customize and select All Commands in the Choose commands from pulldown and then scroll down through the list until you come to Enclose Characters and then click on the Add button. -- 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 "imateacher" wrote in message ... I hope you don't mind my popping into your post, even though it has nothing to do with what I'm looking for. I am going nuts and have no way of finding this info... on a try-it version of word 2007 (that just pops up via something called citrex and doesn't need downloading ) I found a command on the toolbar the enclose text. In this version, it appears as an icon on the font toolbar as a circle with something in it. I have since downloaded the trial of word 07 (to see if I Like it) before buying it, and no 'enclose text' command can be found anywhere... there is no way to add it to the tool bar, and the circle-like icon doesn't exist anywhere. How do I find which version has that, since I can use if a lot... or whether my trial version has it and I'm just missing it somewhere (which I doubt). I already looked at the 'character map' but there is nothing that circles words, or encloses text. I thank you for reading this... I have tried to find a way to email support before purchasing; I have checked the knowledge base and put a search out there all over the place... How the heck do I circle a word or letter in word 2007? I can't find this information anywhere. Google is no longer my friend. If you can help, thanks a lot. If you can't and can direct me elsewhere, I would appreciate that. "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm It may be necessary to turn it into a formula { = 1 * { DOCVARIABLE etc } \# "$,0/00" } -- 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 "GusEvans" wrote in message news Another program has the abitlity to merge its database fields into a Word template. The resulting merged document results in all currency fields having no dollar sign nor commas. The template field directly from the database would be - Additional Amt resulting in - 15000.00 The underlying field code is - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \* MERGEFORMAT } If I try to add formatting to it as in - { DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AdditionalAmt_081859447 \# ###.00 \* MERGEFORMAT } It results in - Additional Amt as text in the document. I just need to get the fields formatted correctly, when pulling them into the template. Thanks for any help. -- Gus Evans |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Word should allow to 'divide' page by 3 or 4, not just 2 | Page Layout | |||
Word applies direct format on File open | Microsoft Word Help |