|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 17th, 2008, 08:09 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Data 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 
|
|
#2
April 17th, 2008, 08:40 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Data truncated when merging from Excel to Word.
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. -- Hope 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 "Teresa" wrote in message ... 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
|
|
#3
April 18th, 2008, 01:23 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Data truncated when merging from Excel to Word.
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 "Doug Robbins - Word MVP" wrote: 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. -- Hope 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 "Teresa" wrote in message ... 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
|
|
#4
April 21st, 2008, 01:04 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Data truncated when merging from Excel to Word.
My data is still truncated and nothing seems to be helping. I'm at a loss.
Does anyone have any suggestions? Thanks, Teresa "Teresa" wrote: 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 "Doug Robbins - Word MVP" wrote: 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. -- Hope 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 "Teresa" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
