Excel currency field not showing as currency in Word Mail merge 1

[BlueHorizon]

Hi Experts!

Thanks in advance for any help -

I have an Excel datalist that I'm using to populate a Word Mail Merge letter. Values formatted as currency with thousand separators, dollar signs and two decimal places are showing up with no formatting and varying decimal places in Word. I've tried formatting the excel values, making sure no values were entered with more than 2 dec. places.

Any ideas how I can fix this?
Much thanks!


Best,
Blue Horizon

 

[SkipVought]

Hi,

No formatting is included when you Mail Merge.

You must set the MergeField display charateristics yourself.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[BlueHorizon]

Thanks, Skip!

That worked! For anyone else interested, here's what I added:

{MERGEFIELD "compensation" \# $####,0.00}

Have a good one!!


Best,
Blue Horizon

 

[SkipVought]

Blue,

I'd like SIX FIGURES in my compensation, thank you! ;-)

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[BlueHorizon]

Skip,

Good one! Check's in the mail!

Best,
Blue Horizon

 

[scott1971]

Guys,

Urgent help needed on this. I understand there is no formatting but I'm not sure how you get the above to work, totally confused. Word isn't my thing but I can usually muddle through this but not this time!

Thanks

Scott1971

 

[SkipVought]

Scott1971,

Please post your question in a new thread.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[macropod]

Hi BlueHorizon,

Using a mergefield formatted as {MERGEFIELD "compensation" \# $####,0.00} will force the output to be padded with spaces if the $ value is between 9 and 10,000. Unless you're merging to a table, that usually isn't wanted and you could use {MERGEFIELD "compensation" \# $,0.00} instead.

Cheers

[MS MVP - Word]