 |
 | 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 / November 2003Mail merging numbers
I have a document that I am mail merging with a letter. The document that is being merged FROM, contains name/street number/street address etc etc All works well with the street number as long as the street number is all numbers(ie 6345 or 1234) but if the address is 123B a zero merges in the document Same if the number is 223#34 I did find a way around by concatating the two(Number & Street name) but would prefer not to have to Any ideas Thanks Ian Norton Professional 2004 says this email is clean...believe it Which version of Word is this? And (probably not relevant, but ...) is the data in a table in a Word document, in a comma- or tab-delimited format, or? -- Peter Jamieson - Word MVP > I have a document that I am mail merging with a letter. > The document that is being merged FROM, contains name/street number/street [quoted text clipped - 9 lines] > Ian > Norton Professional 2004 says this email is clean...believe it I am using Word 2003 and the data is in Excel format (2003) > Which version of Word is this? And (probably not relevant, but ...) is the > data in a table in a Word document, in a comma- or tab-delimited [quoted text clipped - 16 lines] > > Ian > > Norton Professional 2004 says this email is clean...believe it Word 2003 will by default use OLEDB to get data from Excel and it will probably use the first few rows of the data to determine a data type. If it thinks the data is numeric, you will get the kind of problem you are seeing. You can try either a. in Excel, select the column and format the cells as Text (and go through the Word data source selection process again) b. revert to the old default DDE connection process - check Word Tools|Options|General|"Confirm conversions at open", go through the data source selection process again, and select the DDE option when it is presented. -- Peter Jamieson - Word MVP > I am using Word 2003 and the data is in Excel format (2003) > [quoted text clipped - 20 lines] > > > Ian > > > Norton Professional 2004 says this email is clean...believe it |
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.