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:
00582029
Views:
36
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.
Caroline
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform