word merge - Set unicode with OpenDataSource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Albert D. Kallal - 01 Jun 2007 14:18 GMT

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?

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message

Peter Jamieson - 02 Jun 2007 10:47 GMT

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/microsoft.public.word.mailmerge.fields/browse_thr
ead/thread/dc1076d59b977c64/d39588c43fc31d70?lnk=st&q=jamieson+SCHEMA.INI+odc+te
xt+unicode&rnum=1

Peter Jamieson

>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.
[quoted text clipped - 19 lines]
> 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?

Reply to this Message