Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge fields limit
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge fields limit
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. -- 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 "dBNovice" wrote in message ... 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge fields limit
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. -- Peter Jamieson http://tips.pjmsn.me.uk "dBNovice" wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove character limit in mail merge fields. | Mailmerge | |||
Mail Merge: 10,001 Limit | Mailmerge | |||
Mail Merge: 10,001 Limit | Microsoft Word Help | |||
Mail Merge Limit | Mailmerge | |||
mail merge field limit | Mailmerge |