View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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