Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge with Chinese Characters
I'm doing a Mail Merge using an Excel Spreadsheet as the Data source. The
spreadsheet contains English and Chinese Names and addresses. When Merged, the English displays correctly, the Chinese displays as '?????' The Chinese displays correctly in the Excel file. This problem is exhibited on a Win2000 system but works correctly on another machine under XP using the same Template / Data set. Is this a known issue or do i have a configuration problem on the Win2000 system? |
#2
|
|||
|
|||
Which version of /Word/ are you using? Are you using the English language
versions of Windows and Office/Word in both cases? Are you specifying a particular method to connect tot he data source (e.g. DD, OLEDB, ODBC? - if you are not aware of doing so, don't worry, just tell us the version of Word). Also, not sure if this is relevant, but if you are using Word 2002/2003, have you enabled Chinese language features in Office on both machines? Peter Jamieson "Ausmerica" wrote in message ... I'm doing a Mail Merge using an Excel Spreadsheet as the Data source. The spreadsheet contains English and Chinese Names and addresses. When Merged, the English displays correctly, the Chinese displays as '?????' The Chinese displays correctly in the Excel file. This problem is exhibited on a Win2000 system but works correctly on another machine under XP using the same Template / Data set. Is this a known issue or do i have a configuration problem on the Win2000 system? |
#3
|
|||
|
|||
Word version is Word 2000 (9.0.2720)
Not aware of data source connect method. Note: Excel Displays the Chinese correctly in the Data source (Excel 2000), only after the Merge into Word it becomes a string of ?'s "Peter Jamieson" wrote: Which version of /Word/ are you using? Are you using the English language versions of Windows and Office/Word in both cases? Are you specifying a particular method to connect tot he data source (e.g. DD, OLEDB, ODBC? - if you are not aware of doing so, don't worry, just tell us the version of Word). Also, not sure if this is relevant, but if you are using Word 2002/2003, have you enabled Chinese language features in Office on both machines? Peter Jamieson "Ausmerica" wrote in message ... I'm doing a Mail Merge using an Excel Spreadsheet as the Data source. The spreadsheet contains English and Chinese Names and addresses. When Merged, the English displays correctly, the Chinese displays as '?????' The Chinese displays correctly in the Excel file. This problem is exhibited on a Win2000 system but works correctly on another machine under XP using the same Template / Data set. Is this a known issue or do i have a configuration problem on the Win2000 system? |
#4
|
|||
|
|||
More information:
If I cut and paste (Chinese characters) from Excel to Word the result is the same. Chines okay in Excel, garbage in Word. It appears that language support is installed for Excel 200 but not for Word 2000 .... is this possible? JP "Peter Jamieson" wrote: Which version of /Word/ are you using? Are you using the English language versions of Windows and Office/Word in both cases? Are you specifying a particular method to connect tot he data source (e.g. DD, OLEDB, ODBC? - if you are not aware of doing so, don't worry, just tell us the version of Word). Also, not sure if this is relevant, but if you are using Word 2002/2003, have you enabled Chinese language features in Office on both machines? Peter Jamieson "Ausmerica" wrote in message ... I'm doing a Mail Merge using an Excel Spreadsheet as the Data source. The spreadsheet contains English and Chinese Names and addresses. When Merged, the English displays correctly, the Chinese displays as '?????' The Chinese displays correctly in the Excel file. This problem is exhibited on a Win2000 system but works correctly on another machine under XP using the same Template / Data set. Is this a known issue or do i have a configuration problem on the Win2000 system? |
#5
|
|||
|
|||
Hi,
"Don't know" is the simple answer. I'm having a look but there's no guarantee I'll find the answer even when I've set up some tests here. What surprised me about your answer is that by default, Word 2000 would use DDE to connect to Excel. Typically, DDE does not transfer Unicode data and the only other way to get Chinese characters across would be if the relevant pre-Unicode Chinese character set was being used on your Win2k system but not your WinXP system. That's possible, but I'm not sure how you can check. Peter Jamieson "Ausmerica" wrote in message ... More information: If I cut and paste (Chinese characters) from Excel to Word the result is the same. Chines okay in Excel, garbage in Word. It appears that language support is installed for Excel 200 but not for Word 2000 .... is this possible? JP "Peter Jamieson" wrote: Which version of /Word/ are you using? Are you using the English language versions of Windows and Office/Word in both cases? Are you specifying a particular method to connect tot he data source (e.g. DD, OLEDB, ODBC? - if you are not aware of doing so, don't worry, just tell us the version of Word). Also, not sure if this is relevant, but if you are using Word 2002/2003, have you enabled Chinese language features in Office on both machines? Peter Jamieson "Ausmerica" wrote in message ... I'm doing a Mail Merge using an Excel Spreadsheet as the Data source. The spreadsheet contains English and Chinese Names and addresses. When Merged, the English displays correctly, the Chinese displays as '?????' The Chinese displays correctly in the Excel file. This problem is exhibited on a Win2000 system but works correctly on another machine under XP using the same Template / Data set. Is this a known issue or do i have a configuration problem on the Win2000 system? |
#6
|
|||
|
|||
Peter, More information that might be relevant:
Using the same Template / Data source files on another machine running XP / Office 2003 all is okay. The resulting document from the merge can then be opened on the Win2000 machine and displays Chinese okay. The problem seems to lie in the Merge process on the Win2K machine. JP "Peter Jamieson" wrote: Hi, "Don't know" is the simple answer. I'm having a look but there's no guarantee I'll find the answer even when I've set up some tests here. What surprised me about your answer is that by default, Word 2000 would use DDE to connect to Excel. Typically, DDE does not transfer Unicode data and the only other way to get Chinese characters across would be if the relevant pre-Unicode Chinese character set was being used on your Win2k system but not your WinXP system. That's possible, but I'm not sure how you can check. Peter Jamieson "Ausmerica" wrote in message ... More information: If I cut and paste (Chinese characters) from Excel to Word the result is the same. Chines okay in Excel, garbage in Word. It appears that language support is installed for Excel 200 but not for Word 2000 .... is this possible? JP "Peter Jamieson" wrote: Which version of /Word/ are you using? Are you using the English language versions of Windows and Office/Word in both cases? Are you specifying a particular method to connect tot he data source (e.g. DD, OLEDB, ODBC? - if you are not aware of doing so, don't worry, just tell us the version of Word). Also, not sure if this is relevant, but if you are using Word 2002/2003, have you enabled Chinese language features in Office on both machines? Peter Jamieson "Ausmerica" wrote in message ... I'm doing a Mail Merge using an Excel Spreadsheet as the Data source. The spreadsheet contains English and Chinese Names and addresses. When Merged, the English displays correctly, the Chinese displays as '?????' The Chinese displays correctly in the Excel file. This problem is exhibited on a Win2000 system but works correctly on another machine under XP using the same Template / Data set. Is this a known issue or do i have a configuration problem on the Win2000 system? |
#7
|
|||
|
|||
OK, I just want to be sure I am not on a wild goose chase :-)
Windows XP, Word 2003 mailmerge works OK (this is what I would expect if you are using the default connection method in Word 2003, i.e. OLEDB Windows XP, Word 2000 mailmerge works OK (I did not expect this as I thought Word 2000 would always fail). I would like to be sure that you did not mean Windows XP, Word 2003 Windows 2000, Word 2000 mailmerge inserts ????? (Which I would expect) Peter Jamieson "Ausmerica" wrote in message ... Peter, More information that might be relevant: Using the same Template / Data source files on another machine running XP / Office 2003 all is okay. The resulting document from the merge can then be opened on the Win2000 machine and displays Chinese okay. The problem seems to lie in the Merge process on the Win2K machine. JP "Peter Jamieson" wrote: Hi, "Don't know" is the simple answer. I'm having a look but there's no guarantee I'll find the answer even when I've set up some tests here. What surprised me about your answer is that by default, Word 2000 would use DDE to connect to Excel. Typically, DDE does not transfer Unicode data and the only other way to get Chinese characters across would be if the relevant pre-Unicode Chinese character set was being used on your Win2k system but not your WinXP system. That's possible, but I'm not sure how you can check. Peter Jamieson "Ausmerica" wrote in message ... More information: If I cut and paste (Chinese characters) from Excel to Word the result is the same. Chines okay in Excel, garbage in Word. It appears that language support is installed for Excel 200 but not for Word 2000 .... is this possible? JP "Peter Jamieson" wrote: Which version of /Word/ are you using? Are you using the English language versions of Windows and Office/Word in both cases? Are you specifying a particular method to connect tot he data source (e.g. DD, OLEDB, ODBC? - if you are not aware of doing so, don't worry, just tell us the version of Word). Also, not sure if this is relevant, but if you are using Word 2002/2003, have you enabled Chinese language features in Office on both machines? Peter Jamieson "Ausmerica" wrote in message ... I'm doing a Mail Merge using an Excel Spreadsheet as the Data source. The spreadsheet contains English and Chinese Names and addresses. When Merged, the English displays correctly, the Chinese displays as '?????' The Chinese displays correctly in the Excel file. This problem is exhibited on a Win2000 system but works correctly on another machine under XP using the same Template / Data set. Is this a known issue or do i have a configuration problem on the Win2000 system? |
#8
|
|||
|
|||
Windows XP, Word 2003 mailmerge works OK (this is what I would expect if you
are using the default connection method in Word 2003, i.e. OLEDB -- Correct Windows XP, Word 2000 mailmerge works OK (I did not expect this as I thought Word 2000 would always fail). I would like to be sure that you did not mean Windows XP, Word 2003 - --- Don't have this combination. But Merged document created under XP/Word2003 opens correctly on Win2K/Word2K machine Windows 2000, Word 2000 mailmerge inserts ????? (Which I would expect)-- Correct "Peter Jamieson" wrote: OK, I just want to be sure I am not on a wild goose chase :-) Windows XP, Word 2003 mailmerge works OK (this is what I would expect if you are using the default connection method in Word 2003, i.e. OLEDB Windows XP, Word 2000 mailmerge works OK (I did not expect this as I thought Word 2000 would always fail). I would like to be sure that you did not mean Windows XP, Word 2003 Windows 2000, Word 2000 mailmerge inserts ????? (Which I would expect) Peter Jamieson "Ausmerica" wrote in message ... Peter, More information that might be relevant: Using the same Template / Data source files on another machine running XP / Office 2003 all is okay. The resulting document from the merge can then be opened on the Win2000 machine and displays Chinese okay. The problem seems to lie in the Merge process on the Win2K machine. JP "Peter Jamieson" wrote: Hi, "Don't know" is the simple answer. I'm having a look but there's no guarantee I'll find the answer even when I've set up some tests here. What surprised me about your answer is that by default, Word 2000 would use DDE to connect to Excel. Typically, DDE does not transfer Unicode data and the only other way to get Chinese characters across would be if the relevant pre-Unicode Chinese character set was being used on your Win2k system but not your WinXP system. That's possible, but I'm not sure how you can check. Peter Jamieson "Ausmerica" wrote in message ... More information: If I cut and paste (Chinese characters) from Excel to Word the result is the same. Chines okay in Excel, garbage in Word. It appears that language support is installed for Excel 200 but not for Word 2000 .... is this possible? JP "Peter Jamieson" wrote: Which version of /Word/ are you using? Are you using the English language versions of Windows and Office/Word in both cases? Are you specifying a particular method to connect tot he data source (e.g. DD, OLEDB, ODBC? - if you are not aware of doing so, don't worry, just tell us the version of Word). Also, not sure if this is relevant, but if you are using Word 2002/2003, have you enabled Chinese language features in Office on both machines? Peter Jamieson "Ausmerica" wrote in message ... I'm doing a Mail Merge using an Excel Spreadsheet as the Data source. The spreadsheet contains English and Chinese Names and addresses. When Merged, the English displays correctly, the Chinese displays as '?????' The Chinese displays correctly in the Excel file. This problem is exhibited on a Win2000 system but works correctly on another machine under XP using the same Template / Data set. Is this a known issue or do i have a configuration problem on the Win2000 system? |
#9
|
|||
|
|||
Windows XP, Word 2003 - --- Don't have this combination. But Merged
document created under XP/Word2003 opens correctly on Win2K/Word2K machine OK, my guess is that if you actually try to merge this document, you will see the ?????, in other words, you just can't get the Chinese characters via mailmerge from Excel in Word 2000. If you need to be able to do it, I think you will have to cut/paste the Excel sheet into Word then use the Word document as the data source. Make sure you use a format that will copy the Unicode characters (the "Paste Cells" option should do it) and make sure that you use a font that can display Unicode characters such as MS Arial Unicode - I suspect that if you were having trouble with cut-and-pasting these characters before, it is probably because of the font issue. Peter Jamieson "Ausmerica" wrote in message ... Windows XP, Word 2003 mailmerge works OK (this is what I would expect if you are using the default connection method in Word 2003, i.e. OLEDB -- Correct Windows XP, Word 2000 mailmerge works OK (I did not expect this as I thought Word 2000 would always fail). I would like to be sure that you did not mean Windows XP, Word 2003 - --- Don't have this combination. But Merged document created under XP/Word2003 opens correctly on Win2K/Word2K machine Windows 2000, Word 2000 mailmerge inserts ????? (Which I would expect)-- Correct "Peter Jamieson" wrote: OK, I just want to be sure I am not on a wild goose chase :-) Windows XP, Word 2003 mailmerge works OK (this is what I would expect if you are using the default connection method in Word 2003, i.e. OLEDB Windows XP, Word 2000 mailmerge works OK (I did not expect this as I thought Word 2000 would always fail). I would like to be sure that you did not mean Windows XP, Word 2003 Windows 2000, Word 2000 mailmerge inserts ????? (Which I would expect) Peter Jamieson "Ausmerica" wrote in message ... Peter, More information that might be relevant: Using the same Template / Data source files on another machine running XP / Office 2003 all is okay. The resulting document from the merge can then be opened on the Win2000 machine and displays Chinese okay. The problem seems to lie in the Merge process on the Win2K machine. JP "Peter Jamieson" wrote: Hi, "Don't know" is the simple answer. I'm having a look but there's no guarantee I'll find the answer even when I've set up some tests here. What surprised me about your answer is that by default, Word 2000 would use DDE to connect to Excel. Typically, DDE does not transfer Unicode data and the only other way to get Chinese characters across would be if the relevant pre-Unicode Chinese character set was being used on your Win2k system but not your WinXP system. That's possible, but I'm not sure how you can check. Peter Jamieson "Ausmerica" wrote in message ... More information: If I cut and paste (Chinese characters) from Excel to Word the result is the same. Chines okay in Excel, garbage in Word. It appears that language support is installed for Excel 200 but not for Word 2000 .... is this possible? JP "Peter Jamieson" wrote: Which version of /Word/ are you using? Are you using the English language versions of Windows and Office/Word in both cases? Are you specifying a particular method to connect tot he data source (e.g. DD, OLEDB, ODBC? - if you are not aware of doing so, don't worry, just tell us the version of Word). Also, not sure if this is relevant, but if you are using Word 2002/2003, have you enabled Chinese language features in Office on both machines? Peter Jamieson "Ausmerica" wrote in message ... I'm doing a Mail Merge using an Excel Spreadsheet as the Data source. The spreadsheet contains English and Chinese Names and addresses. When Merged, the English displays correctly, the Chinese displays as '?????' The Chinese displays correctly in the Excel file. This problem is exhibited on a Win2000 system but works correctly on another machine under XP using the same Template / Data set. Is this a known issue or do i have a configuration problem on the Win2000 system? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Word Mail Merge with QueryString longer than 255 characters | Mailmerge | |||
How do I mail merge fields exceeding 255 characters from Excel to. | Mailmerge | |||
International characters in mail merge | Mailmerge |