Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Word and CodePages
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00580898
Message ID:
00582006
Views:
30
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform