 |
 | 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 / February 2008Non-breaking space in a merge.
How to you code a merge field to change spaces to non-breaking spaces in the variable text (coming from an Excel Spreadsheet where it won't let you insert non-breaking spaces)? Hi MGEAdmin, You'll need to change the data source - Excel should allow you to replace your existing spaces (Chr 32) with a non-breaking space (Chr 160). Cheers  Signaturemacropod [MVP - Microsoft Word] ------------------------- > How to you code a merge field to change spaces to non-breaking spaces in the > variable text (coming from an Excel Spreadsheet where it won't let you insert > non-breaking spaces)? Using an excel data file it will allow me to change my spaces in Excel but once I attach the data source to the Main Document and merge the file I lose the non-breaking space still. Is this because I am using an Excel data source? > Hi MGEAdmin, > [quoted text clipped - 5 lines] > > variable text (coming from an Excel Spreadsheet where it won't let you insert > > non-breaking spaces)? AFAICS the no-break spaces will only get through from Excel if you are able to use the old Excel converter to get the data, or use Edit|Copy, Edit|Paste into Word, or something similar, and use that as your data source. every other method of connecting to Excel (OLE DB, ODBC, and even DDE) changes the Chr 160 to a space. Personally I would try to avoid using the Converter - it has been obsolescent since Office 2002 and has one or two other problems, but you can get it from Graham Mayor's site at http://www.gmayor.com/downloads.htm SignaturePeter Jamieson http://tips.pjmsn.me.uk > Using an excel data file it will allow me to change my spaces in Excel but > once I attach the data source to the Main Document and merge the file I [quoted text clipped - 14 lines] >> > insert >> > non-breaking spaces)? |
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.