A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

merged document field not displaying all source data



 
 
Thread Tools Display Modes
  #1  
Old March 17th, 2010, 08:27 PM posted to microsoft.public.word.mailmerge.fields
JHeckman
external usenet poster
 
Posts: 2
Default merged document field not displaying all source data

[Win Vista, Office 2007 SP2]
I'm using a single Excel spreadsheet as a data source for a Word merged
document. My problematic field is 'comments.' While the merged doc DOES show
multi-lines, it cuts off after about 250 characters of source data. Is there
a field switch I can use to eliminiate this problem?

  #2  
Old March 17th, 2010, 10:11 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default merged document field not displaying all source data

Using the default method of connection to the database, the type of data in
each field is deduced from the first eight or so records so if those records
do have sufficiently long comments associated with them, the data type may
be deduced to one with a limit of 255/256 characters.

You should be able to overcome the issue if in Word, you click on the Office
Button and then on Word Options and go to the Advanced tab and scroll down
to the General section of the dialog and check the box for "Confirm file
format conversion on open". Then when you attach your data source to the
mail merge main document, a Confirm Data Source dialog will open. Click on
the Show all box on this dialog and then select the MS Excel Worksheets via
DDE (*.xls) method of connection.

The alternative is to insert some dummy records at the top of the data
source that contain comments longer than 256 characters.

--
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, originally posted via msnews.microsoft.com

"JHeckman" wrote in message
...
[Win Vista, Office 2007 SP2]
I'm using a single Excel spreadsheet as a data source for a Word merged
document. My problematic field is 'comments.' While the merged doc DOES
show
multi-lines, it cuts off after about 250 characters of source data. Is
there
a field switch I can use to eliminiate this problem?

  #3  
Old March 18th, 2010, 09:28 PM posted to microsoft.public.word.mailmerge.fields
JHeckman
external usenet poster
 
Posts: 2
Default merged document field not displaying all source data

Checking "Confirm...Format" box did not work. The false data field @ the top
works like a charm. THANK YOU!!

"Doug Robbins - Word MVP" wrote:

Using the default method of connection to the database, the type of data in
each field is deduced from the first eight or so records so if those records
do have sufficiently long comments associated with them, the data type may
be deduced to one with a limit of 255/256 characters.

You should be able to overcome the issue if in Word, you click on the Office
Button and then on Word Options and go to the Advanced tab and scroll down
to the General section of the dialog and check the box for "Confirm file
format conversion on open". Then when you attach your data source to the
mail merge main document, a Confirm Data Source dialog will open. Click on
the Show all box on this dialog and then select the MS Excel Worksheets via
DDE (*.xls) method of connection.

The alternative is to insert some dummy records at the top of the data
source that contain comments longer than 256 characters.

--
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, originally posted via msnews.microsoft.com

"JHeckman" wrote in message
...
[Win Vista, Office 2007 SP2]
I'm using a single Excel spreadsheet as a data source for a Word merged
document. My problematic field is 'comments.' While the merged doc DOES
show
multi-lines, it cuts off after about 250 characters of source data. Is
there
a field switch I can use to eliminiate this problem?

 




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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.