Microsoft Office Forums Mail Merge truncating 'some' of the text fields......Not sure what to do

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-24-2010, 07:35 AM
sssb2000 sssb2000 is offline Mail Merge truncating 'some' of the text fields......Not sure what to do Windows XP Mail Merge truncating 'some' of the text fields......Not sure what to do Office 2007
Novice
Mail Merge truncating 'some' of the text fields......Not sure what to do
 
Join Date: Sep 2010
Posts: 6
sssb2000 is on a distinguished road
Default Mail Merge truncating 'some' of the text fields......Not sure what to do


Hello all,
i have an excel sheet that i'm using to create 50 or so word documents. some of my text cells in excel are getting truncated (at 256 characters) once brought into word. however, some cells with a thousand or more characters are 'not' getting truncated! bizzare!
i did a google search and found that i need to get the windows 2000 service pack 1 to increase the limit to 50k. but i have windows 2007 on XP! can't get the windows 2000 service pack1! and i already have the latest service pack for 07 anyway.

Any thoughts? I'd greatly appreciate your help.

ps. i've tried opening the excel "via DDE" but i get an error that says windows encountered a problem and has to close.
Reply With Quote
  #2  
Old 09-25-2010, 07:31 AM
Kimberly Kimberly is offline Mail Merge truncating 'some' of the text fields......Not sure what to do Windows 7 Mail Merge truncating 'some' of the text fields......Not sure what to do Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Word looks at the data in the first record in the datasource in order to decide what you need. I suspect that some of your fields are merging OK because they have more than 256 characters in the first record. Edit the first record so that it has more than 256 characters in any fields that are long for some records.


To do the DDE thing, follow these steps:
In Word 2007...Office Button >
Word Options > Advanced > General > Confirm file format conversion on open
Then close Word and re-open, reconnect to the Excel file and then you will be given the option of connecting via DDE

If you have Window XP, you do not need a service pack for Windows 2000. The problem you are having is a common complaint about mail merge and does not indicate anything about what service packs you have.
Reply With Quote
  #3  
Old 09-26-2010, 07:57 AM
sssb2000 sssb2000 is offline Mail Merge truncating 'some' of the text fields......Not sure what to do Windows XP Mail Merge truncating 'some' of the text fields......Not sure what to do Office 2007
Novice
Mail Merge truncating 'some' of the text fields......Not sure what to do
 
Join Date: Sep 2010
Posts: 6
sssb2000 is on a distinguished road
Default

Quote:
Originally Posted by Kimberly View Post
Word looks at the data in the first record in the datasource in order to decide what you need. I suspect that some of your fields are merging OK because they have more than 256 characters in the first record. Edit the first record so that it has more than 256 characters in any fields that are long for some records.


To do the DDE thing, follow these steps:
In Word 2007...Office Button >
Word Options > Advanced > General > Confirm file format conversion on open
Then close Word and re-open, reconnect to the Excel file and then you will be given the option of connecting via DDE

If you have Window XP, you do not need a service pack for Windows 2000. The problem you are having is a common complaint about mail merge and does not indicate anything about what service packs you have.
Thank you for your reply.
Could you please explain what you mean by the blue text above? (what's a first record?)
Also, i verified and i have word 2002. sorry.
but i did get to your steps and the problem is that once i try to open the excel, word forces itself to close.
Reply With Quote
  #4  
Old 09-26-2010, 08:45 AM
Kimberly Kimberly is offline Mail Merge truncating 'some' of the text fields......Not sure what to do Windows 7 Mail Merge truncating 'some' of the text fields......Not sure what to do Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

A record is a row. The first record is the row of data that is closest to the top of the sheet.

"once i try to open the excel, word forces itself to close"
Why are you opening Excel after Word is open?
Reply With Quote
  #5  
Old 09-26-2010, 08:56 AM
sssb2000 sssb2000 is offline Mail Merge truncating 'some' of the text fields......Not sure what to do Windows XP Mail Merge truncating 'some' of the text fields......Not sure what to do Office 2007
Novice
Mail Merge truncating 'some' of the text fields......Not sure what to do
 
Join Date: Sep 2010
Posts: 6
sssb2000 is on a distinguished road
Default

Quote:
Originally Posted by Kimberly View Post
A record is a row. The first record is the row of data that is closest to the top of the sheet.

"once i try to open the excel, word forces itself to close"
Why are you opening Excel after Word is open?
ok, each word document that i'm creating is a row (A3:FW55).
one of the cells that's giving me trouble is BE12. it's got like 350 characters and only 255 show up. (there are other cells that have 1000 characters and show up fine).
so, based on what you said, i put in text in BE1 with 500 or so characters. BE12 is still showing up truncated (i reconnected the excel so i know it was updated). is this what you meant i should do?

regarding your question....i'm not opening excel again. i meant that when i click to "link" the excel document to my word, it asks me to open the excel with DDE which i select, and then word says something like: word encountered an error and has to close. and then it forces it to close!
Reply With Quote
  #6  
Old 09-26-2010, 09:40 AM
Kimberly Kimberly is offline Mail Merge truncating 'some' of the text fields......Not sure what to do Windows 7 Mail Merge truncating 'some' of the text fields......Not sure what to do Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

So that I am sure I understand, you're going to do a mail merge 50 times, using one row per document. You have more than 255 characters in some of the 180 columns. When you connect via DDE, you get a error that is something like "word encountered an error and has to close".

Sorry, I don't know how to help. Maybe someone else will. Good luck.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge question: Using fields connected to a CSV file in Word 2007 Mr_Luke Mail Merge 0 06-18-2010 10:11 AM
How do I set up the fields in mail merge word 07 from my data base mbcrabber Mail Merge 4 06-06-2010 01:25 PM
Mail Merge Fitting Text to Fields frnk4760 Mail Merge 1 05-18-2010 04:51 PM
Merge fields & Drop down menu's ShadeTree Word 0 03-09-2010 08:19 AM
Paragraph Breaks In Mail Merge Fields SamuelT Mail Merge 0 09-25-2008 06:38 AM


All times are GMT -7. The time now is 01:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft