 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / April 2004Special Characters in Mail Merge
Hi, I have a datasouce file with special characters like Z and z. When I try to merge this file with the MS Word 2000 template, Word is not able to recognize these two characters and replaces them with (unknown character). The ascii values of those two characters are 142 and 158 respectively. My datasource file is in ANSII encoding and these characters are in the extended ascii list, hence Word must support them right? Further, if I manually paste these characters into the Word doc, Word accepts them without any issues. Kindly help!!!! Awaiting response GP Hi Gp, If you OPEN this text file in Word, then "save as" as a Word document and use that as the data source - does that work correctly? Most likely, mail merge is not picking up the correct code page (this has been an increasingly critical problem since Word 2000 came out). I know of only one other way around it: defining and using an ODBC configuration expressly for older character sets. But which approach is best depends a lot on the situation and your preference... > I have a datasouce file with special characters like Z > and z. When I try to merge this file with the MS Word [quoted text clipped - 7 lines] > Further, if I manually paste these characters into the > Word doc, Word accepts them without any issues. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Hi, Saving the datasource file as a word doc did not help. Z got converted to . Thanks for that update GP >-----Original Message----- >Hi Gp, > >If you OPEN this text file in Word, then "save as" as a Word document and use that as the data source - does that work correctly? >Most likely, mail merge is not picking up the correct code page (this has been an increasingly critical problem since Word 2000 came out). I know of only one other way around it: defining and using an ODBC configuration expressly for older character sets. But which approach is best depends a lot on the situation and your preference... >> I have a datasouce file with special characters like Z >> and z. When I try to merge this file with the MS Word [quoted text clipped - 14 lines] > >This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e- mail :-) >. Hi Gp, > Saving the datasource file as a word doc did not help That's very odd; that usually does work. The characters appeared correctly when opened into Word, though? And you did choose "Word document" from the File type list when saving as a Word document? (Just typing .doc instead of .txt won't do it) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.