Mail merge using Excel

Hi Dierdre,

Sorry for the delay in responding.

Have you managed to resolve your problem?

I have found a possible solution. Please try this:

1. Add the mail merge fields.
2. Use Alt + F9 to show the merge codes
3. e.g. {MERGEFIELD "Fieldname" }
4. Change the code for the cash field to this:
5. {MERGEFIELD "Fieldname"\#0.00x}

This should format the cash field to show two decimal places.

I hope this answers your question.

Regards

Simon