Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
I am doing a Mail merge document with SQL 2000 as my data source. There are
some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
Did you update the field after adding the switch?
{Mergefield Fieldname \# ",0.00" } Is '.' your regional decimal separator? What *exactly* does {Mergefield Fieldname} produce? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I am doing a Mail merge document with SQL 2000 as my data source. There are some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
Yes, I update the field after adding the switch. The '.' is my Regional
Decimal seperator. If I look at the record in SQL the data is like 1232.0034 and this is exactly what shows up in Word. "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Fieldname \# ",0.00" } Is '.' your regional decimal separator? What *exactly* does {Mergefield Fieldname} produce? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I am doing a Mail merge document with SQL 2000 as my data source. There are some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,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 "Paresh Gupta" wrote in message ... Yes, I update the field after adding the switch. The '.' is my Regional Decimal seperator. If I look at the record in SQL the data is like 1232.0034 and this is exactly what shows up in Word. "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Fieldname \# ",0.00" } Is '.' your regional decimal separator? What *exactly* does {Mergefield Fieldname} produce? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I am doing a Mail merge document with SQL 2000 as my data source. There are some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
How to add this field within field.....
Thanks "Doug Robbins - Word MVP" wrote: Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,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 "Paresh Gupta" wrote in message ... Yes, I update the field after adding the switch. The '.' is my Regional Decimal seperator. If I look at the record in SQL the data is like 1232.0034 and this is exactly what shows up in Word. "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Fieldname \# ",0.00" } Is '.' your regional decimal separator? What *exactly* does {Mergefield Fieldname} produce? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I am doing a Mail merge document with SQL 2000 as my data source. There are some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
Use CTRL+F9 for the brackets and type the rest.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: How to add this field within field..... Thanks "Doug Robbins - Word MVP" wrote: Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,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 "Paresh Gupta" wrote in message ... Yes, I update the field after adding the switch. The '.' is my Regional Decimal seperator. If I look at the record in SQL the data is like 1232.0034 and this is exactly what shows up in Word. "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Fieldname \# ",0.00" } Is '.' your regional decimal separator? What *exactly* does {Mergefield Fieldname} produce? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I am doing a Mail merge document with SQL 2000 as my data source. There are some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
I keep getting
Invalid Character string....... "Graham Mayor" wrote: Use CTRL+F9 for the brackets and type the rest. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: How to add this field within field..... Thanks "Doug Robbins - Word MVP" wrote: Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,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 "Paresh Gupta" wrote in message ... Yes, I update the field after adding the switch. The '.' is my Regional Decimal seperator. If I look at the record in SQL the data is like 1232.0034 and this is exactly what shows up in Word. "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Fieldname \# ",0.00" } Is '.' your regional decimal separator? What *exactly* does {Mergefield Fieldname} produce? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I am doing a Mail merge document with SQL 2000 as my data source. There are some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
In that case you haven't entered it correctly.
There are two sets of field brackets each inserted with CTRL+F9 to produce { = { MERGEFIELD [fieldname] } * 1 \# "$,0.00" } [fieldname] is replaced by the actual fieldname of the errant field from your data source. The rest is typed exactly as it appears above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I keep getting Invalid Character string....... "Graham Mayor" wrote: Use CTRL+F9 for the brackets and type the rest. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: How to add this field within field..... Thanks "Doug Robbins - Word MVP" wrote: Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,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 "Paresh Gupta" wrote in message ... Yes, I update the field after adding the switch. The '.' is my Regional Decimal seperator. If I look at the record in SQL the data is like 1232.0034 and this is exactly what shows up in Word. "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Fieldname \# ",0.00" } Is '.' your regional decimal separator? What *exactly* does {Mergefield Fieldname} produce? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I am doing a Mail merge document with SQL 2000 as my data source. There are some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
wHATEVER i TRY, i AM GETTING THE iNVALID CHARACTER STRING... Any more clues
"Graham Mayor" wrote: In that case you haven't entered it correctly. There are two sets of field brackets each inserted with CTRL+F9 to produce { = { MERGEFIELD [fieldname] } * 1 \# "$,0.00" } [fieldname] is replaced by the actual fieldname of the errant field from your data source. The rest is typed exactly as it appears above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I keep getting Invalid Character string....... "Graham Mayor" wrote: Use CTRL+F9 for the brackets and type the rest. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: How to add this field within field..... Thanks "Doug Robbins - Word MVP" wrote: Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,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 "Paresh Gupta" wrote in message ... Yes, I update the field after adding the switch. The '.' is my Regional Decimal seperator. If I look at the record in SQL the data is like 1232.0034 and this is exactly what shows up in Word. "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Fieldname \# ",0.00" } Is '.' your regional decimal separator? What *exactly* does {Mergefield Fieldname} produce? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I am doing a Mail merge document with SQL 2000 as my data source. There are some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
Send me your document and a small sample of data to the link on my web site
home page -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: wHATEVER i TRY, i AM GETTING THE iNVALID CHARACTER STRING... Any more clues "Graham Mayor" wrote: In that case you haven't entered it correctly. There are two sets of field brackets each inserted with CTRL+F9 to produce { = { MERGEFIELD [fieldname] } * 1 \# "$,0.00" } [fieldname] is replaced by the actual fieldname of the errant field from your data source. The rest is typed exactly as it appears above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I keep getting Invalid Character string....... "Graham Mayor" wrote: Use CTRL+F9 for the brackets and type the rest. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: How to add this field within field..... Thanks "Doug Robbins - Word MVP" wrote: Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,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 "Paresh Gupta" wrote in message ... Yes, I update the field after adding the switch. The '.' is my Regional Decimal seperator. If I look at the record in SQL the data is like 1232.0034 and this is exactly what shows up in Word. "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Fieldname \# ",0.00" } Is '.' your regional decimal separator? What *exactly* does {Mergefield Fieldname} produce? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I am doing a Mail merge document with SQL 2000 as my data source. There are some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
#11
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with SQL 2000
What I have done is sent you a mail with a ZIP file called MERGE.ZIP. This
contains 3 files as follows MERGE.SQL : The sql script to create a sample table and insert data into it in SQL 2000 MERGE_MAIN.DOC: The main mail merge document which just puts the 2 fields from the table created above MERGED.DOC: The final Merged document. I am sending you a mail from the link on your website. Thanks "Graham Mayor" wrote: Send me your document and a small sample of data to the link on my web site home page -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: wHATEVER i TRY, i AM GETTING THE iNVALID CHARACTER STRING... Any more clues "Graham Mayor" wrote: In that case you haven't entered it correctly. There are two sets of field brackets each inserted with CTRL+F9 to produce { = { MERGEFIELD [fieldname] } * 1 \# "$,0.00" } [fieldname] is replaced by the actual fieldname of the errant field from your data source. The rest is typed exactly as it appears above. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I keep getting Invalid Character string....... "Graham Mayor" wrote: Use CTRL+F9 for the brackets and type the rest. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: How to add this field within field..... Thanks "Doug Robbins - Word MVP" wrote: Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,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 "Paresh Gupta" wrote in message ... Yes, I update the field after adding the switch. The '.' is my Regional Decimal seperator. If I look at the record in SQL the data is like 1232.0034 and this is exactly what shows up in Word. "Graham Mayor" wrote: Did you update the field after adding the switch? {Mergefield Fieldname \# ",0.00" } Is '.' your regional decimal separator? What *exactly* does {Mergefield Fieldname} produce? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Paresh Gupta wrote: I am doing a Mail merge document with SQL 2000 as my data source. There are some Money fields which are coming on the Mail merge document, but whatever I do, they come with 4 decimal places. I have tried the Numeric Switches \# #0.00, but to no avail. Version of Word is 2003 Please help |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E-mail as output Word 2000 Mail merge | Mailmerge | |||
Advantage of Mail Merge 2003 over Mail Merge 2000 | Mailmerge | |||
Word 2000 mail merge documents won't save Access 2000 data source | Mailmerge | |||
Mail merge to e-mail in word 2000? | Mailmerge | |||
mail merge - Access 2000 and Word 2000 | Mailmerge |