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