Losing Decimal Place In Mail Merge

[abbaddon223]

Hi,

I'm hoping someone can help with a frustrating problem please?

My DB is merge in a currency field set to 2 decimal places into word. It's doing this by declaring the fields as variable, calling an instance of work then dropping the values into the bookmarks. All works fine....

When a value is £360.64 is fine, but when it's something that ends with a 0 (£360.60) - is loses the 0 giving me £360.6.

Can anyone help with this please as it's driving me nuts!!!

Phil.

 

[Cronk]

Firstly, if your merge is based on a table in your database, create a query with all of the fields you need.

Add a new column to the query
FormattedCurrency: Format([YourCurrencyField],"Currency")

Use the data in FormattedCurrency in your merge.

 

[pr2-eugin]

Even if you do that your Mail Merge will loose the last zero.. How do I know? Because I have had that troubles.. I did everything I could but finally all I needed was..

{MERGEFIELD [COLOR=Blue]YourCurrencyField[/COLOR]  \##,###.00}

This should be done in the Merge template.. Change the highlighted section to your actual field name..