Help merging japanese characters

[jennifer72401]

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

 

[Doug Robbins - Word MVP]

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.

--
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

 

[Peter Jamieson]

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