Merge with CSV. Encoding problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janfry - 13 Jun 2007 01:04 GMT

Hi.

Using Word 2003 SP2, when I link the datasource, a csv file, to the
document, appears a dialog to select the text encoding: Windows (default),
MSDOS, Other.

Programming with VBA, that dialog does not appear, but the document
generated from the merging, the characters with accent (á,é, etc...) are seen
like "squares" or japanese characters.

The Document.Open method has a parameter to specify the Encoding, but
MailMerge.OpenDataSource does not include it.

Is there any way to not appear that dialog and specify the encoding?

Thanks,

Janfry

Reply to this Message

Peter Jamieson - 13 Jun 2007 02:14 GMT

First, can you try creating the Windows registry entry described in the
following article:

http://support.microsoft.com/kb/290981/en-us

(I don't know whether it's relevant in this situation, and you may need to
choose a different code page from the one mentioned in there).

If that doesn't work, there's only one way I know to do this, and it can
only work for data sources with 255 columns or fewer. You'll find a
description in my post in the following conversation:

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

> Hi.
>
[quoted text clipped - 15 lines]
>
> Janfry

Reply to this Message

Rate this thread: