Mail Merge with SQL 2000

[Paresh Gupta]

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

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Paresh Gupta]

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.

 

[Doug Robbins - Word MVP]

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]

How to add this field within field.....

Thanks

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

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]

Use CTRL+F9 for the brackets and type the rest.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

How to add this field within field.....

Thanks

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

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.

:

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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

 

[Paresh Gupta]

I keep getting
Invalid Character string.......

Use CTRL+F9 for the brackets and type the rest.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

How to add this field within field.....

Thanks

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

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.

:

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

I keep getting
Invalid Character string.......

Use CTRL+F9 for the brackets and type the rest.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

How to add this field within field.....

Thanks

:

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

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.

:

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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

 

[Paresh Gupta]

wHATEVER i TRY, i AM GETTING THE iNVALID CHARACTER STRING... Any more clues

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

I keep getting
Invalid Character string.......

Use CTRL+F9 for the brackets and type the rest.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Paresh Gupta wrote:
How to add this field within field.....

Thanks

:

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

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.

:

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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

 

[Graham Mayor]

Send me your document and a small sample of data to the link on my web site
home page

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

wHATEVER i TRY, i AM GETTING THE iNVALID CHARACTER STRING... Any more
clues

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

I keep getting
Invalid Character string.......

:

Use CTRL+F9 for the brackets and type the rest.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Paresh Gupta wrote:
How to add this field within field.....

Thanks

:

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

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.

:

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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

 

[Paresh Gupta]

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

Send me your document and a small sample of data to the link on my web site
home page

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

wHATEVER i TRY, i AM GETTING THE iNVALID CHARACTER STRING... Any more
clues

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



Paresh Gupta wrote:
I keep getting
Invalid Character string.......

:

Use CTRL+F9 for the brackets and type the rest.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Paresh Gupta wrote:
How to add this field within field.....

Thanks

:

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

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.

:

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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