Thanks, Carole
>In July 2001 MSND library - the article is titled "Mail Merge: Part 1" (I found it by searching on "unicode and mailmerge"). The paragraphs above the section headed "Excel Workbooks"
>
>HTH
>
>>Where could I find that MS note?
>>
>>>Thanks for that Yuri.
>>>
>>>I also have just found the MS note that basically says Word will not do it - not very helpful but I guess that's MS for you.
>>>
>>>>Jeremy,
>>>>
>>>>I was not able to use this approach for mailmerge, but only while inserting txt file into word document.
>>>>The workaround for mailmerge could be (and it works for me):
>>>>- copy from table to Excel
>>>>- replace values in Excel cells containing euro symbol via Excel automation, like ActiveCell.FormulaR1C1 = "ˆ"
>>>>- then word mailmerge procedure recognizes excel data and euro symbol in it.
>>>>
>>>>Thanks to MS for headache.
>>>>
>>>>>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?
>>>>>
>>>>>>Jeremy,
>>>>>>
>>>>>>I do not know how to change a Code Page, but I do know how to avoid conflict.
>>>>>>At least, it works for me. Try this:
>>>>>>*------------------
>>>>>>close table all
>>>>>>create curs temp (lceuro c(1))
>>>>>>insert into temp values (chr(128))
>>>>>>insert into temp values (chr(128))
>>>>>>copy to c:\temp1 sdf
>>>>>>lcstr=filetostr("c:\temp1.txt")
>>>>>>lcstr=strtran(lcstr, chr(128), chr(255)+chr(254)+chr(172)+chr(32))
>>>>>>strtofile(lcstr, "c:\temp2.txt")
>>>>>>*-----------------------------------
>>>>>>
>>>>>>Two text files will be seen differently in MS Word.
>>>>>>I will appreciate if you share with me another solution if any.
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Hi can anyone out there help.
>>>>>>>
>>>>>>>I perform a mailmerge in Word to do some reports. The merge data is a comma delimited text file create from VF5. However when the Euro symbol is used it appear in word as a small box. I think this has something to do with the Code Page but I've been unable to trace where I set this in Word :-(
>>>>>>>
>>>>>>>Any help would be appreciated.