Truncation of text when using mail merge.
 

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.

"Macy" wrote:

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?

The information in the following newsgroup post may help you:


http://groups.google.ca/group/micros...aa36b6e?hl=en&

Macy wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Unfortunately, I can see all the text in excel, but when I perform the mail
merge the data from the excel spreadsheet becomes truncated.

"Mike" wrote:

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.

"Macy" wrote:

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?

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?

"Debra Dalgleish" wrote:

The information in the following newsgroup post may help you:


http://groups.google.ca/group/micros...aa36b6e?hl=en&

Macy wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

Macy wrote:
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?

"Debra Dalgleish" wrote:


The information in the following newsgroup post may help you:


http://groups.google.ca/group/micros...aa36b6e?hl=en&

Macy wrote:

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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html