Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2006

Tip: Looking for answers? Try searching our database.

Chinese character and mail merge problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rickywk@gmail.com - 16 May 2006 16:36 GMT
I got a problem when using mail merge. I have a excel file which is the
merge source, it contains some simplified chinese character.

When I use mail merge, some character changed to "?", but not all of
chinese character have problem.

My working environment is WinXP + Office2k03/Office 2k

Here is my sample:
http://www.hk235m.net/downloads/book1.xls
http://www.hk235m.net/downloads/docu-2.doc

If I switch to WindowsNT environment, RichWin installed(GBK code) and
using office 2k, the result is correct, no more "?" sign

Any comments are welcome~!
Thx!
Peter Jamieson - 16 May 2006 18:15 GMT
In your example, Word is connecting to the Excel sheet using DDE (which is
the default connection method in Word 2000). If you connect to the Excel
sheet using the default method for Word 2003 (OLEDB), I think you will see
all the Chinese characters as long as you are using a font in Word that
supports them.

You should be able to switch to OLEDB by disconnecting the data source and
reconnecting.

In English-language WIndows, I would not expect to see any Chinese
characters at all when connecting using DDE. I do not have Chinese-language
Windows but I would only expect to see Chinese characters if they were
encoded as Multibyte-character-set characters in the default encoding used
on Chinese-language Windows, and the font in Word supported them. Since you
see the characters when you use Richwin (which I do not have either) I
suspect that it may be providing something that makes it work in
Windows/Word 2000 with DDE.

Peter Jamieson

>I got a problem when using mail merge. I have a excel file which is the
> merge source, it contains some simplified chinese character.
[quoted text clipped - 13 lines]
> Any comments are welcome~!
> Thx!
rickywk@gmail.com - 17 May 2006 16:23 GMT
Ah...!
I forget Microsoft Applocale utility, my home PC can merge the excel
without any problem.
I will try it tomorrow.
rickywk@gmail.com - 18 May 2006 16:29 GMT
Some status update.

Applocale + Office2k still have "?" in the mail merge result.
Finally, I switch my XP default encoding to Chinese (PRC), it solved.
Peter Jamieson - 18 May 2006 17:22 GMT
Thanks for the feedback...

Peter Jamieson
> Some status update.
>
> Applocale + Office2k still have "?" in the mail merge result.
> Finally, I switch my XP default encoding to Chinese (PRC), it solved.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.