A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Microsoft Word Help
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Mail merge cuts off some text, how do i fix this?



 
 
Thread Tools Display Modes
  #1  
Old January 30th 08, 01:06 AM posted to microsoft.public.word.docmanagement
k&p
external usenet poster
 
Posts: 2
Default Mail merge cuts off some text, how do i fix this?

I have a report that pulls info into excel in preparation for a mail merge
report in word.

One of the mail merge fields contains a string of text that is 279
characters (including spaces).

When merged into the Word document, it seems to cut it off at 255 characters.

Is there a limit to how much text I can import into a mail merge document?
If not, is there a way to fix this?

Thank you in advance!
Ads
  #2  
Old January 30th 08, 07:13 PM posted to microsoft.public.word.docmanagement
k&p
external usenet poster
 
Posts: 2
Default Mail merge cuts off some text, how do i fix this?

Found another post that was dealing with the same issue.
Here's the instructions from the other post. Works great!

From the Tools menu in Word, select Options and then go to the General tab
and check the box against "Confirm conversions at open" Then when you
attach the data source, choose the DDE option in the dialog box that asks
you for the method by which the connection to the data source should be
made. I think that this will overcome the 255 character limit that you are
up against at the moment.


"k&p" wrote:

I have a report that pulls info into excel in preparation for a mail merge
report in word.

One of the mail merge fields contains a string of text that is 279
characters (including spaces).

When merged into the Word document, it seems to cut it off at 255 characters.

Is there a limit to how much text I can import into a mail merge document?
If not, is there a way to fix this?

Thank you in advance!

  #3  
Old December 19th 19, 05:07 PM
maksr maksr is offline
Junior Member
 
First recorded activity by WordBanter: Dec 2019
Posts: 0
Default

In Word 2007 choose "All Word documents..."

Quote:
Originally Posted by k&p View Post
...Then when you
attach the data source, choose the DDE option in the dialog box that asks
you for the method
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
e-Mail word doc cuts page UCSD Microsoft Word Help 1 September 9th 06 12:41 AM
Border cuts off top of text jen_writer Tables 2 August 24th 06 07:53 PM
Word merge sometimes cuts off words BAW Mailmerge 3 March 13th 06 09:19 PM
Short Cuts Sue Peacock Microsoft Word Help 2 October 18th 05 07:00 AM
mail merge all text in col 1 All text appears in first space of line Mailmerge 1 July 12th 05 03:18 PM


All times are GMT +1. The time now is 11:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.