Problems converting international characters with Excel Mail Merge...

Article View: bit.mailserv.word-pc

Article #160

Back to bit.mailserv.word-pc Previous Next

#160

From: Greg Mouning
Date: Wed, 02 Apr 2003 22:02

47 lines
2709 bytes

Hi,

I am trying to perform a formletter mail merge using a
Word97 template and Excel 97 spreadsheet as the
datasource. The problem I encounter is with the following
international character set:

�  �  �  �  �  �  &#256;  &#258;  &#260;      �  �  �  �  �  �  &#257;
&#259;  &#261;
�  &#262;  &#264;  &#266;  &#268;    �  &#263;  &#265;  &#267;  &#269;
&#270;  &#272;    &#271;  &#273;
�  �  �  �  &#274;  &#276;  &#278;  &#280;  &#282;    �  �  �  �  &#275;
&#277;  &#279;  &#281;  &#283;
&#284;  &#286;  &#288;  &#290;    &#285;  &#287;  &#289;  &#291;
&#292;  &#294;    &#293;  &#295;
�  �  �  �  &#296;  &#298;  &#300;  &#302;  &#304;    �  �  �  �  &#297;
&#299;  &#301;  &#303;  &#305;
&#308;    &#309;
&#310;    &#311;  &#312;
&#313;  &#315;  &#317;  &#319;  &#321;    &#314;  &#316;  &#318;  &#320;
&#322;
�  &#323;  &#325;  &#327;  &#330;    �  &#324;  &#326;  &#328;  &#329;
&#331;
�  �  �  �  �  �  &#332;  &#334;  &#336;    �  �  �  �  �  �  &#333;  &#335;
&#337;
&#340;  &#342;  &#344;    &#341;  &#343;  &#345;
&#346;  &#348;  &#350;  S    &#347;  &#349;  &#351;  s
&#354;  &#356;  &#358;    &#355;  &#357;  &#359;
�  �  �  �  &#360;  &#362;  &#364;  &#366;  &#368;  &#370;    �  �  �  �
&#361;  &#363;  &#365;  &#367;  &#369;
&#371;
&#372;    &#373;
�  &#374;  Y    �  �  &#375;
&#377;  &#379;  Z    &#378;  &#380;  z


Once the mail merge has generated a new merge file, it
does not convert the above characters correctly. However,
I can perform the same mail merge using a Word97 document
as my datasource and it works fine. Can someone tell me if
there is a fix for this problem? I would like to use Excel
as my datasource.

Thanks in advance for any assistance you can provide.

Greg Mouning
greg.mouning@yale.edu

Technical Details

Message-ID: <85ad1a3.0304021402.4af9f863@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 106cba,be18fb901c315ab7,start
X-Google-Attributes: gid106cba,public
X-Google-ArrivalTime: 2003-04-02 14:02:33 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: greg.mouning@yale.edu (Greg Mouning)
Newsgroups: bit.mailserv.word-pc
Subject: Problems converting international characters with Excel Mail Merge...
Date: 2 Apr 2003 14:02:32 -0800
Organization: http://groups.google.com/
Lines: 47
Message-ID: <85ad1a3.0304021402.4af9f863@posting.google.com>
NNTP-Posting-Host: 130.132.124.12
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1049320953 22157 127.0.0.1 (2 Apr 2003 22:02:33 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 2 Apr 2003 22:02:33 GMT