 |
 | 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 2008Data truncated when merging from Excel to Word.
My data is truncated when I am merging from an excel file to a word document. I have merged this large of cells before with no problem, I'm not sure why it's not working now. Can anyone tell me if there is a way to ensure the field accepts all data, not just the first 260 characters. Thanks, Teresa In Word, select Options from the Tools menu and then go to the General tab and check the box against the "Confirm conversions at open" item, then when you attach the data source to the mail merge main document, select the DDE option. The reason that it may have stopped working with the method that you were previously using could be that there were no records with that many characters in that field in the first so-many records in the data source, which is used as a basis for determining the type of data that is in each field.  SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > My data is truncated when I am merging from an excel file to a word > document. [quoted text clipped - 3 lines] > Thanks, > Teresa Hi Doug, Thanks for the suggestion, however, that didn't work. It couldn't connect through the DDE. The only difference is that the first workbook that I used actually had those cells filled with a vlookup formula verses full text. I'm going to try to go back to the vlookup and see if that works. I don't know. If that works, I'll post the results, otherwise, I'll keep looking for a solution. Thanks, Teresa > In Word, select Options from the Tools menu and then go to the General tab > and check the box against the "Confirm conversions at open" item, then when [quoted text clipped - 14 lines] > > Thanks, > > Teresa My data is still truncated and nothing seems to be helping. I'm at a loss. Does anyone have any suggestions? Thanks, Teresa > Hi Doug, > Thanks for the suggestion, however, that didn't work. It couldn't connect [quoted text clipped - 24 lines] > > > Thanks, > > > Teresa |
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.