Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Truncated merge fields
I have an excel sheet with some cell contents of about 500 characters
When I merge this in to word the fields are truncated at 255 characters I understand that this is a throw back to previous limits, but why does it happen? I have looked at cell format etc etc I am not using tables etc just merge fields in a simple word document I have read previous threads in this group and using Doug Robbins idea have managed to make the merge work by saving the excel sheet as as a csv file and merging that. This may work but its inconvienent Anyone have any ideas? Many thanks Pete |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Truncated merge fields
I believe that the advice concerning the use of a .csv file was more to do
with wanting to be able to use more than 255 fields which is the limit for the number of columns or fields in Excel and Access respectively. The way around the 255 character per field limit is the change the method of connection to the data source to DDE. To do that, select Options from the Tools menu in Word and go to the General tab and check the box against "Confirm conversions at open" Then when you attach the data source to the mail merge main document, select DDE as the method by which the connection should be made. -- 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 "Pete" wrote in message ... I have an excel sheet with some cell contents of about 500 characters When I merge this in to word the fields are truncated at 255 characters I understand that this is a throw back to previous limits, but why does it happen? I have looked at cell format etc etc I am not using tables etc just merge fields in a simple word document I have read previous threads in this group and using Doug Robbins idea have managed to make the merge work by saving the excel sheet as as a csv file and merging that. This may work but its inconvienent Anyone have any ideas? Many thanks Pete |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Truncated merge fields
Doug
Thank you - but I can not get this to work properly at all. It seems to muddle the merge fields and merges the wrong data I am using some fields more than once - is this a proplem Word can merge longer than 255 using the default connection so why does it sometimes not do so? csv works ok - hopefully word 12 will sort it out ! Thanks pete "Doug Robbins - Word MVP" wrote: I believe that the advice concerning the use of a .csv file was more to do with wanting to be able to use more than 255 fields which is the limit for the number of columns or fields in Excel and Access respectively. The way around the 255 character per field limit is the change the method of connection to the data source to DDE. To do that, select Options from the Tools menu in Word and go to the General tab and check the box against "Confirm conversions at open" Then when you attach the data source to the mail merge main document, select DDE as the method by which the connection should be made. -- 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 "Pete" wrote in message ... I have an excel sheet with some cell contents of about 500 characters When I merge this in to word the fields are truncated at 255 characters I understand that this is a throw back to previous limits, but why does it happen? I have looked at cell format etc etc I am not using tables etc just merge fields in a simple word document I have read previous threads in this group and using Doug Robbins idea have managed to make the merge work by saving the excel sheet as as a csv file and merging that. This may work but its inconvienent Anyone have any ideas? Many thanks Pete |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Truncated merge fields
Using the fields more than once should not cause a problem and the method of
connection should not muddle the fields. Perhaps you need to check the mail merge main document. -- 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 "Pete" wrote in message ... Doug Thank you - but I can not get this to work properly at all. It seems to muddle the merge fields and merges the wrong data I am using some fields more than once - is this a proplem Word can merge longer than 255 using the default connection so why does it sometimes not do so? csv works ok - hopefully word 12 will sort it out ! Thanks pete "Doug Robbins - Word MVP" wrote: I believe that the advice concerning the use of a .csv file was more to do with wanting to be able to use more than 255 fields which is the limit for the number of columns or fields in Excel and Access respectively. The way around the 255 character per field limit is the change the method of connection to the data source to DDE. To do that, select Options from the Tools menu in Word and go to the General tab and check the box against "Confirm conversions at open" Then when you attach the data source to the mail merge main document, select DDE as the method by which the connection should be made. -- 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 "Pete" wrote in message ... I have an excel sheet with some cell contents of about 500 characters When I merge this in to word the fields are truncated at 255 characters I understand that this is a throw back to previous limits, but why does it happen? I have looked at cell format etc etc I am not using tables etc just merge fields in a simple word document I have read previous threads in this group and using Doug Robbins idea have managed to make the merge work by saving the excel sheet as as a csv file and merging that. This may work but its inconvienent Anyone have any ideas? Many thanks Pete |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Truncated merge fields
In the thread "Remove character limit from merge fields" BHodge reports that
using a DDE connection "totally worked". -- 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 "Pete" wrote in message ... Doug Thank you - but I can not get this to work properly at all. It seems to muddle the merge fields and merges the wrong data I am using some fields more than once - is this a proplem Word can merge longer than 255 using the default connection so why does it sometimes not do so? csv works ok - hopefully word 12 will sort it out ! Thanks pete "Doug Robbins - Word MVP" wrote: I believe that the advice concerning the use of a .csv file was more to do with wanting to be able to use more than 255 fields which is the limit for the number of columns or fields in Excel and Access respectively. The way around the 255 character per field limit is the change the method of connection to the data source to DDE. To do that, select Options from the Tools menu in Word and go to the General tab and check the box against "Confirm conversions at open" Then when you attach the data source to the mail merge main document, select DDE as the method by which the connection should be made. -- 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 "Pete" wrote in message ... I have an excel sheet with some cell contents of about 500 characters When I merge this in to word the fields are truncated at 255 characters I understand that this is a throw back to previous limits, but why does it happen? I have looked at cell format etc etc I am not using tables etc just merge fields in a simple word document I have read previous threads in this group and using Doug Robbins idea have managed to make the merge work by saving the excel sheet as as a csv file and merging that. This may work but its inconvienent Anyone have any ideas? Many thanks Pete |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Truncated merge fields
I understand that this is a throw back to previous limits, but why does it
happen? Unfortunately it is not the case that this is a throwback to previous limits - the limits on text length are determined by the Jet ODBC driver/OLEDB provider which is what Word uses to get Excel data when it isn't using DDE. Even those limits can be confusing because the Jet provider can be in one of two (or three, I forget) modes. In other words, - none of the methods are especially reliable - the older method is a better bet than the newer method - it sounds as if the csv method is the best of the lot. Peter Jamieson "Pete" wrote in message ... I have an excel sheet with some cell contents of about 500 characters When I merge this in to word the fields are truncated at 255 characters I understand that this is a throw back to previous limits, but why does it happen? I have looked at cell format etc etc I am not using tables etc just merge fields in a simple word document I have read previous threads in this group and using Doug Robbins idea have managed to make the merge work by saving the excel sheet as as a csv file and merging that. This may work but its inconvienent Anyone have any ideas? Many thanks Pete |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get all mail merge fields in a document | Mailmerge | |||
Truncated fields in Excel-Word merge | Mailmerge | |||
truncated merge fields | Mailmerge | |||
excel/word merge: why are some data fields partially truncated? | Mailmerge | |||
Can you create a multi-layered merge where certain merge fields a. | Mailmerge |