Unfortunately I didn't have Word 2000 available to check. With Word 2003 you
get the extra option and that does indeed work as I suggested - sorry

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


wcsdropout wrote:
Hi Peter,
Thanks very much for the info. That would explain why my
attempts at trying Graham's suggestion did not work.
Unfortunately, I probably won't use the workaround because the
purpose of setting up an excel spreadsheet for my vocabulary lists
was to allow the flexibility of sorting, filtering, formatting, etc.
inherent in Excel. If I have to copy and paste lists into word, I
might as well make my flashcards in word in the first place by
inserting tables on each page, instead of using mail merge for
mailing labels.

Thanks,
Susan

"Peter Jamieson" wrote:

The problem is that none of the "connection methods" available for
getting Excel data in Word 2000 (DDE, ODBC, and the Excel Converter)
will preserve the Hebrew characters.

The simplest workaround is probably
a. open your Excel sheet
b. select the data
c. Edit|Copy
d. open a blank Word document
e. Edit|Paste

This can only work if you have around 63 columns or less in your
spreadsheet - otherwise, you will need to remove some columns before
copying.

Use the Word document as your data source. I can't re-test that on
Word 2000 right now. It certainly works on Word 2003, with correct
preservation of the right-to-left sequence.

Peter Jamieson




"wcsdropout" wrote in message
...
I have Windows XP with Microsoft Office 2000 Professional. I
installed Hebrew language support and am using a Yiddish keyboard
layout. I have an Excel
spreadsheet with vocabulary words -- 1 column English and 1
Yiddish, and am
trying to print out the Yiddish Words to Microsoft Word "labels"
using Mail
Merge. However, whenever I try to merge them, I get "????" in all
the fields. I have tried changing all my column headers to English
language, but
that doesn't help.

Has anyone dealt with this problem before?