Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
More Mail Merge truncating
I've been reading the threads and trying the advice to no avail. When I merge
into Word 2003 from an Excel spreadsheet that's pulling data off a SQL Server, two fields are truncated at 255, but a third is not. I've tried padding the first row, but it doesn't work, nor does chosing the connection method. Any ideas? thanks, Linda |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
More Mail Merge truncating
Have you confirmed that the data is complete in the Excel spreadsheet?
Maybe the truncation is between the SQL Server and Excel. -- 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 "cheshirecat" wrote in message news I've been reading the threads and trying the advice to no avail. When I merge into Word 2003 from an Excel spreadsheet that's pulling data off a SQL Server, two fields are truncated at 255, but a third is not. I've tried padding the first row, but it doesn't work, nor does chosing the connection method. Any ideas? thanks, Linda |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
More Mail Merge truncating
Yes, I have. The data is complete in Excel.
"Doug Robbins - Word MVP" wrote: Have you confirmed that the data is complete in the Excel spreadsheet? Maybe the truncation is between the SQL Server and Excel. -- 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 "cheshirecat" wrote in message news I've been reading the threads and trying the advice to no avail. When I merge into Word 2003 from an Excel spreadsheet that's pulling data off a SQL Server, two fields are truncated at 255, but a third is not. I've tried padding the first row, but it doesn't work, nor does chosing the connection method. Any ideas? thanks, Linda |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
More Mail Merge truncating
Then you need to look at the difference between the data for the one field
that merges correctly and those that don't. -- 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 "cheshirecat" wrote in message ... Yes, I have. The data is complete in Excel. "Doug Robbins - Word MVP" wrote: Have you confirmed that the data is complete in the Excel spreadsheet? Maybe the truncation is between the SQL Server and Excel. -- 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 "cheshirecat" wrote in message news I've been reading the threads and trying the advice to no avail. When I merge into Word 2003 from an Excel spreadsheet that's pulling data off a SQL Server, two fields are truncated at 255, but a third is not. I've tried padding the first row, but it doesn't work, nor does chosing the connection method. Any ideas? thanks, Linda |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
More Mail Merge truncating
where would I look? in Excel? In Word? In SQL? Does it matter how the field
types are defined in SQL? I've copied data from the incorrectly merging fields into Word and Notepad to compare them against what's working and the only noticible difference in the non-truncating fields is that they start and end with angle brackets (because it's XML strings). "Doug Robbins - Word MVP" wrote: Then you need to look at the difference between the data for the one field that merges correctly and those that don't. -- 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 "cheshirecat" wrote in message ... Yes, I have. The data is complete in Excel. "Doug Robbins - Word MVP" wrote: Have you confirmed that the data is complete in the Excel spreadsheet? Maybe the truncation is between the SQL Server and Excel. -- 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 "cheshirecat" wrote in message news I've been reading the threads and trying the advice to no avail. When I merge into Word 2003 from an Excel spreadsheet that's pulling data off a SQL Server, two fields are truncated at 255, but a third is not. I've tried padding the first row, but it doesn't work, nor does chosing the connection method. Any ideas? thanks, Linda |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
More Mail Merge truncating
The trouble with "the advice" is that none of the methods of connecting to
Excel data (or any other kind of data) can be guaranteed to do what you need: each has its own limitations, and there are quite a few. In this case, are you in a position to connect directly to the SQL Server? If so, that still may not solve the problem, but it may well cut out the "middle man". Peter Jamieson "cheshirecat" wrote in message news I've been reading the threads and trying the advice to no avail. When I merge into Word 2003 from an Excel spreadsheet that's pulling data off a SQL Server, two fields are truncated at 255, but a third is not. I've tried padding the first row, but it doesn't work, nor does chosing the connection method. Any ideas? thanks, Linda |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
More Mail Merge truncating
I didn't want to go that route since I don't know SQL, but found a colleague
who does and we think this will work just fine. Thanks to everyone! "Peter Jamieson" wrote: The trouble with "the advice" is that none of the methods of connecting to Excel data (or any other kind of data) can be guaranteed to do what you need: each has its own limitations, and there are quite a few. In this case, are you in a position to connect directly to the SQL Server? If so, that still may not solve the problem, but it may well cut out the "middle man". Peter Jamieson "cheshirecat" wrote in message news I've been reading the threads and trying the advice to no avail. When I merge into Word 2003 from an Excel spreadsheet that's pulling data off a SQL Server, two fields are truncated at 255, but a third is not. I've tried padding the first row, but it doesn't work, nor does chosing the connection method. Any ideas? thanks, Linda |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
More Mail Merge truncating
Did anyone ever find an answer to this? I'm having the same problem...
"cheshirecat" wrote: I've been reading the threads and trying the advice to no avail. When I merge into Word 2003 from an Excel spreadsheet that's pulling data off a SQL Server, two fields are truncated at 255, but a third is not. I've tried padding the first row, but it doesn't work, nor does chosing the connection method. Any ideas? thanks, Linda |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
More Mail Merge truncating
1. The answer that seemed to work for the original poster was
"connecting directly to SQL Server" - is that an option for you? 2. Can you be more precise about how you are padding the first row? IMO a necessary condition for this to work would be that the cell in the column where the data is truncated would need to contain a string which was longer than 255 characters after trailing white space (and possibly leading white space) is removed.. However, that may well not be a sufficient condition. Peter Jamieson http://tips.pjmsn.me.uk egordon wrote: Did anyone ever find an answer to this? I'm having the same problem... "cheshirecat" wrote: I've been reading the threads and trying the advice to no avail. When I merge into Word 2003 from an Excel spreadsheet that's pulling data off a SQL Server, two fields are truncated at 255, but a third is not. I've tried padding the first row, but it doesn't work, nor does chosing the connection method. Any ideas? thanks, Linda |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NO CODE - mail merge to Outlook with attachment with CC | Mailmerge | |||
Heavy Mail Merge Application | Mailmerge | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
How to stop Word from truncating data in an mail merge field? | Mailmerge | |||
mail merge with attachments | Mailmerge |