Truncation of text when using mail merge.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would appreciate any assistance. The text in my excel spreadsheet is being
truncated when perfoming a mail merge into Word. I'm running Office 2003.
Is there any way I can maintain all the text when performing mail merge?
 
excel limits how much text is displayed
Go to your Excel help menu and enter limits
I believe 1024 has been the magic number for years.
 
Unfortunately, I can see all the text in excel, but when I perform the mail
merge the data from the excel spreadsheet becomes truncated.
 
I have tried the suggestions in the web page. However, when I select DDE I'm
no longer able to select the worksheet from which to pull the data when
performing a mail merge. Do you haev any additional suggestions?
 
As far as I know, with DDE it will select the first sheet in the
workbook. Can you move the sheet so it's first?

Otherwise, try one of the other suggestions in that post. Maybe if you
put one of the records with lots of text near the top of your list, it
will force all of them to import correctly.

If not, you could post your question in the Word mail merge newsgroup,
and someone may be able to help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Data problem from Excel to Word 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Getting word wrap to work in a merged cell 1
Mail Merge Problem 1
Maintaining currency formatting in a Mail Merge? 2
Why does my excel to word mail merged doc not merge last entry? 3
Using Mail Merge in Excel 2007 1
Mail Merge (Excel to Excel) 1

Back
Top