>>>>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 :-)
Thanks I'll look into that tomorrow.
Caroline