Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2008

Tip: Looking for answers? Try searching our database.

Mail Merge fields limit

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dBNovice - 21 Feb 2008 20:43 GMT
I am using Word 2007 that I am trying to merge in more than 256 data
fields from an excel 2007 file.  But it seems Word is only seeing the
1st 255 data fields in excel.  Is there a way to get past this so I
only need 1 word document that can merge all of the excel fields.
Doug Robbins - Word MVP - 21 Feb 2008 21:44 GMT
I believe that this is a limitation imposed by the method of connection to
the data source.  In Word, click on the Pizza Button and then on Customize
in the bottom border of the dialog and then click on the Advance item and
scroll down to the General section and check the box against the "Confirm
file format conversion at open" item.  Then when you connect to the data
source you will be presented with a dialog in which you can specifiy the
method of connection.  Try the DDE option.

Signature

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

>I am using Word 2007 that I am trying to merge in more than 256 data
> fields from an excel 2007 file.  But it seems Word is only seeing the
> 1st 255 data fields in excel.  Is there a way to get past this so I
> only need 1 word document that can merge all of the excel fields.
Peter Jamieson - 22 Feb 2008 09:59 GMT
Unless something has chnaged in the SP1 release of Office 2007, none of the
available methods lets you see more than 255 columns. When I tested here,
the DDE method was actually worse than it has been in previous versions.
When I raised the issue, the problem was described as a "Product
Limitation", which I think means that no-one is ever going to attempt to
overcome it, but I'm not completely sure about that.

If that is still true, your only option is to export to a delimited text
file and see if Word can connect to that Word has a converter that may still
be able to read more than 255 columns. /But/ Word can also have difficulties
connecting to such data sources.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I am using Word 2007 that I am trying to merge in more than 256 data
> fields from an excel 2007 file.  But it seems Word is only seeing the
> 1st 255 data fields in excel.  Is there a way to get past this so I
> only need 1 word document that can merge all of the excel fields.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.