General information
Category:
COM/DCOM and OLE Automation
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only