>>>Yuri,
>>>
>>>I think I understand what you are doing (converting the Euro sign to Unicode text) however if I use that converted file as a mailmerge data file Word will not open it :(
>>>
>>>Any thoughts? .......
>>
>>Have you try to replace the euro sign with something else and automate a search and replace for this character in Word after the merge?
>>
>>HTH :-)
>
>I guess that's the next step now that I've exhausted the possibility of doing it properly.
>
>Is a "replace all" in Word automation as straight forward as it should be?

Look in the vba help file for the correct syntax.

I have done something like this in the past to insert special char like checkbox in a grid.

The first thing to do in these case was to select the entire document and perform the replace in the selection object from VBA.

HTH :-)