Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge in word 2007 of excel2007 file 256 columns (in fact 400
Hi,
I'm trying to mailmerge an excel 2007 data source which has about 400 columns into word 2007 using the mail merge facility. Problem is, mail merge only shows 256 columns. Is there a way that it can display all fields not limited by 256? Please respond ASAP. Thanks in advance |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge in word 2007 of excel2007 file 256 columns (in fact 400
Unfortunately not. None of the methods that Word can use to connect to Excel
data can "see" more than 255 columns. Your best bet is to save your worksheet as .csv format (and possibly rename it so that it has a .txt extension) and try to use that, and/or Edit|Copy, Edit|Paste to a new Word document (Word should not attempt to create a table in this case because it allows even fewer columns) and try to use that. -- Peter Jamieson http://tips.pjmsn.me.uk "Briza" wrote in message ... Hi, I'm trying to mailmerge an excel 2007 data source which has about 400 columns into word 2007 using the mail merge facility. Problem is, mail merge only shows 256 columns. Is there a way that it can display all fields not limited by 256? Please respond ASAP. Thanks in advance |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge in word 2007 of excel2007 file 256 columns (in fact
Thanks for the response.
Thats pretty stupid that the new version of excel has had its columns increased but not mail merge in word. 1) Is there any chance that microsoft will extend this in the short term future? 2) Also, is there a way two have the 400 columns split into 2 lots of 200 column data sources and import both together? 3) Futhermore, does microsoft access also have the 256 column limitation? "Peter Jamieson" wrote: Unfortunately not. None of the methods that Word can use to connect to Excel data can "see" more than 255 columns. Your best bet is to save your worksheet as .csv format (and possibly rename it so that it has a .txt extension) and try to use that, and/or Edit|Copy, Edit|Paste to a new Word document (Word should not attempt to create a table in this case because it allows even fewer columns) and try to use that. -- Peter Jamieson http://tips.pjmsn.me.uk "Briza" wrote in message ... Hi, I'm trying to mailmerge an excel 2007 data source which has about 400 columns into word 2007 using the mail merge facility. Problem is, mail merge only shows 256 columns. Is there a way that it can display all fields not limited by 256? Please respond ASAP. Thanks in advance |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge in word 2007 of excel2007 file 256 columns (in fact
2) Also, is there a way two have the 400 columns split into 2 lots of 200 column data sources and import both together? Not using mailmerge. You may be able to get the data out using ADO, but it may not be able to "see" anything beyond column 255/256, even named ranges that start at column 201 and end at column 400. I haven't tried this. If you can get ADO to work you would probably be better off "rolling your own" merge, e.g. using DOCVARIABLE fields to insert the data. 3) Futhermore, does microsoft access also have the 256 column limitation? Yes (probably 255 or possibly even 127). As far as I know, all Microsoft's "desktop database drivers" (which are mostly Jet drivers/providers or its successor, ACE) and providers have a 255 maximum - even SQL Server. 1) Is there any chance that microsoft will extend this in the short term future? We are volunteers and do not work for Microsoft, so all I can say is that I reported this specific problem some time ago and it was described as a "Product Limitation". I do not know what that means in terms of future fixes. I have also tried to point out that it is becoming increasingly difficult to work with any kind of data source beyond this limit. However, the focus in 2007 was clearly on the user interface, the XML file formats, and as far as working with "data sources" is concerned, on Content controls - I suspect the "approved" way to do this kind of thing would now consist of a bunch of .NET code to transform your Excel worksheet's data, stuff it into the appropriate data portion of a WOrd XML file, open the WOrd document and let Word fill the content controls from that XML data. But there's nothing in that lot for the non-technical Word user. -- Peter Jamieson http://tips.pjmsn.me.uk "Briza" wrote in message ... Thanks for the response. Thats pretty stupid that the new version of excel has had its columns increased but not mail merge in word. 1) Is there any chance that microsoft will extend this in the short term future? 2) Also, is there a way two have the 400 columns split into 2 lots of 200 column data sources and import both together? 3) Futhermore, does microsoft access also have the 256 column limitation? "Peter Jamieson" wrote: Unfortunately not. None of the methods that Word can use to connect to Excel data can "see" more than 255 columns. Your best bet is to save your worksheet as .csv format (and possibly rename it so that it has a .txt extension) and try to use that, and/or Edit|Copy, Edit|Paste to a new Word document (Word should not attempt to create a table in this case because it allows even fewer columns) and try to use that. -- Peter Jamieson http://tips.pjmsn.me.uk "Briza" wrote in message ... Hi, I'm trying to mailmerge an excel 2007 data source which has about 400 columns into word 2007 using the mail merge facility. Problem is, mail merge only shows 256 columns. Is there a way that it can display all fields not limited by 256? Please respond ASAP. Thanks in advance |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fact Sheet Page Layout | Page Layout | |||
Word 2007 and Outlook 2007 e-mail MailMerge does not complete | Mailmerge | |||
Mailmerge using columns instead of rows | Mailmerge | |||
Mailmerge Invert columns for flashcards | Mailmerge | |||
Add chapter numbers to captions after-the-fact | Microsoft Word Help |