Help merging japanese characters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jennifer72401 - 15 Feb 2006 23:40 GMT

I have an excel spreadsheet that is used as my data to be merged into Word.
The spreadsheet is mainly in japanese. When i view the merged data in word,
the japanese characters show up as a bunch of questionmarks. I have the asian
language fonts installed from the 'regional and language' control panel. Is
there anything else i need to isntall for this to work? I have windows xp and
office 2003

Reply to this Message

Doug Robbins - Word MVP - 16 Feb 2006 05:02 GMT

If you can ask this question in Japanese, you may be more likely to get help
if you ask in microsoft.public.jp.word.

Have you tried setting the language for the fields to Japanese? Also, try
formatting the cells in Excel as Text and using DDE as the method of
connection to the Data Source. To do that, form the Tools menu in Word,
select Options and then go to the General tab and check the box for "Confirm
conversions at open" Then when you attach the datasource, you will get the
opportunity to specify the method of connection.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have an excel spreadsheet that is used as my data to be merged into Word.
> The spreadsheet is mainly in japanese. When i view the merged data in
[quoted text clipped - 6 lines]
> and
> office 2003

Reply to this Message

Peter Jamieson - 19 Feb 2006 17:32 GMT

If Doug's suggestions don't help and the number of columns in your sheet is
less than around 63, try copying the entire sheet, pasting it into a blank
Word document, and using that as the data source.

Peter Jamieson

Reply to this Message