Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > Word-Excel mail merge garbles foreign characters

Word-Excel mail merge garbles foreign characters
Thread Tools
Mac Enthusiast
Join Date: Jan 2001
Location: Leesburg, Virginia
Status: Offline
Reply With Quote
Dec 17, 2003, 01:40 AM
 
Has anyone else seen this, where when I do a mail merge of address data in Excel to an envelope in Word, umlauts and accented vowels get messed up? Are there workarounds?

For example, an "ô" in the street address in Excel turns into a "Ù" on the envelope in Word. This is very annoying.

Dominik Hoffmann
     
Mac Enthusiast
Join Date: Jan 2001
Location: Leesburg, Virginia
Status: Offline
Reply With Quote
Jul 21, 2004, 12:27 PM
 
I have since found the solution. However, I don't exactly recall, what it was. I seem to remember it had to do with formatting the Excel columns with "Text" or "Number," where appropriate, rather than with "General."

Dominik Hoffmann
     
   
Thread Tools
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 10:23 AM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2