Hi, We have a notes field in our Housing Software which, when we use a pound sign in (£), it outputs them as a rectangle character once it's been processed through mail merge in Word?

Didn't know if this relates to a setting in the Word client to do with character mapping or something?

Hope someone can help

Hi Calastein,

That suggests your Housing Software has its own font and uses a non-standard character for the £ symbol.

You might be able to overcome this by:
• selecting the problem mergefield,
• pressing Ctrl-F9 to embed the problem mergefield in another field (ie { «Data» })
• editing the field construction so that you end up with {=«Data» \# "£,0.00"}

If that doesn't work, you'll need to format the mergefield with the same font (not just one with the same name) that your Housing Software uses.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi, thanks for the advice, I had thought about formatting the merge field as you suggested but often the Notes field in the Housing System has not only amounts but freeform text also so it's not always the same output.

I checked the fonts but they are the same - This morning the £ are coming out as letter J's for some reason?

Thanks again

Hi Calastein,

There might be some corruption in the font file. You could try deleting & reinstalling it.

Alternatively, maybe there's some corruption in your mailmerge main document. Does the font display all characters correctly in another document?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]