Hi Graham,
Thanks for your response. Unfortunately, it is not working for me yet.
When I select the "Select Method" Checkbox when I open the data source, I
get 3 options: Microsoft Excel Worksheet via Converter, MS Excel Worksheets
via DDE, and Excel Files via ODBC. I have tried all options, but none seems
to work. One problem might be that I can't do step 3; no matter how often I
select the merge field, or the entire document, and select language Hebrew,
the language remains English. I have tried changing my Excel column headings
back to Hebrew/Yiddish words with no effect other than to have the merge
field read "Autoformat" instead of an English heading.
If I select the "Show All" checkbox in the Confirm Data Source dialog,
I get many other options for all office programs, but none that says OLE db.
I have also set the Tools options general - set Confirm conversion on
open like you said in step 1, but it never seemed to actually open the
appropriate dialog unless I selected the "Select Method" checkbox in the Open
Data Source dialog.
Thanks,
Susan
"Graham Mayor" wrote:
I have never done this with Yiddish, but with Greek and English where the
issues are similar:
1. From Tools options general - set Confirm conversion on open. When you
open add data file to the merge document - choose the OLE DB database
option. This works for Word 2003 and I am pretty sure that the same option
was available in Word 2000.
2. Change any \*mergeformat switch on the mergefield to a \*charformat
switch or add a \charformat switch if there is no \*mergeformat switch:
http://www.gmayor.com/formatting_word_fields.htm
3. Set the language of the field to Yiddish.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
wcsdropout wrote:
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?