word merge - Set unicode with OpenDataSource

[Albert D. Kallal]

I have some automaton code, and I trying to set the csv (text) file as
Unicode, and thus avoid the prompt that asks for Unicode.

I can't find a way to set that Unicode. I tried the macro recorder..and I
get:


ActiveDocument.MailMerge.OpenDataSource Name:= _
"C:\Documents and Settings\Albert\My
Documents\Access\WordMerge20\Word\zoo\merge.888" _
, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:="", SQLStatement:="",
SQLStatement1 _
:="", SubType:=wdMergeSubTypeOther


Nothing in the above hints at setting the Unicode. And, if I run the
macro...it don't set.

Since I know the text file used for the word merge is Unicode (it generated
by another system), can I set the mail merge as Unicode?

 

[Peter Jamieson]

The OpenDataSource statement itself doesn't let you specify an encoding.

Other than opening the .csv programmatically (i.e. not as a data source) and
saving it as a .doc, I only know one way that you /might/ be able to do
this - it will only work for files with 255 data columns or fewer, and you
need a .odc file and a SCHEMA.INI file to do it. For further info. have a
look at the conversation at

http://groups.google.com/group/micr...q=jamieson+SCHEMA.INI+odc+text+unicode&rnum=1

Peter Jamieson