Reply
 
Thread Tools Display Modes
  #1   Report Post  
Nondejuu
 
Posts: n/a
Default Difficulties mail merging special characters from excel to word 20

The following is the problem description:

We have enormous difficulties with printing letters etc. for our Czech and
Slovak customers. The problem is the Hyphenations. Especially when you have
to do a mail merge (word letter with excel data source). The problem is that
after a letter merge the result of the letters contain lots of question
marks. These question marks show up in the text at the places where (for us
special) letters have been used. The computer just doesn't recognize these
(for us special) letters.


The following is what we have done so far:

We are using office 2000. I have looked in knowledge bases on microsoft.com
and the rest of internet but can't find something about this issue which
helps me further. The special characters are displayed and printed correctly
from excel. But when merged to word, they are replaced by (red) question
marks. It seems to me then this isn't a font case. Also, when just cut and
paste from execel to word the characters are displayed and printed correctly.
I have also changed the default printer between pcl en ps printer drivers.
This also doesn't make any difference for the merge. Have you any idea where
to look?

Thanks in advance for your response!

  #2   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default

From the Tools menu in Word, select Options and go to the General tab and
then check the box against the item "Confirm conversions at open". After
doing this, when you attach the data source to the mailmerge main document,
you will be asked which connection method to use. Try the different methods
that are offered and see if one of them overcomes the problem - probably the
DDE option.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Nondejuu" wrote in message
...
The following is the problem description:

We have enormous difficulties with printing letters etc. for our Czech and
Slovak customers. The problem is the Hyphenations. Especially when you
have
to do a mail merge (word letter with excel data source). The problem is
that
after a letter merge the result of the letters contain lots of question
marks. These question marks show up in the text at the places where (for
us
special) letters have been used. The computer just doesn't recognize these
(for us special) letters.


The following is what we have done so far:

We are using office 2000. I have looked in knowledge bases on
microsoft.com
and the rest of internet but can't find something about this issue which
helps me further. The special characters are displayed and printed
correctly
from excel. But when merged to word, they are replaced by (red) question
marks. It seems to me then this isn't a font case. Also, when just cut and
paste from execel to word the characters are displayed and printed
correctly.
I have also changed the default printer between pcl en ps printer drivers.
This also doesn't make any difference for the merge. Have you any idea
where
to look?

Thanks in advance for your response!


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
In typing dates in Word, i.e. "January 12" how do you keep the "1. Carol Microsoft Word Help 2 January 12th 05 08:09 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 04:12 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
How to change merge forms from Word Perfect to Microsoft Word dollfindance Microsoft Word Help 2 December 30th 04 03:35 PM


All times are GMT +1. The time now is 07:34 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"