Mail Merge problem

R

RMP

A mail merge is being completed for around 200 letters.

Each letter contains a monetary amount as part of the mail merge. The
problem is that every number that ends with a zero after the decimal place
shows as a number without any decimal places in the letter itself.

eg: number in spreadsheet = £3000.10
number in mail merge = £3000

Any ideas?

Thanks in advance.
 
P

Peter Jamieson

Have you used any formatting switches in your mergefield, e.g.

{ MERGEFIELD myamount \#£0 }

(use Alt-F9 to toggle the merge field codes on/off)?

If you use something like

{ MERGEFIELD myamount \#"£,0.00" }

does that make any difference (or maybe that is what you are already doing?)

Otherwise...

What is the data source? In particular, if it's Access, or perhaps Excel, is
the amount field defined as a "Currency" data type in there?

Which version of Word?

If it's Access and a "Currency" type field, there can be problems in some
cases. Other than changing the data type of the column (which is likely to
have knock-on effects and which you may not be in a position to do), the
simplest fix is probably to define a new query that does something like

SELECT *,cdbl(myamount) As [myamount2] FROM mytable

to change the Currency value to a "regular" number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top