Is there a limit on the number of merge fields I can use?
Hi!
In my experience, there has always been a 255 field limit in Excel. Thought
this was solved in version 2007 (still searching an authorized answer to
this).
I've always been forced to use a workaround: e.g from SPSS in my case (not
tried from Excel): Export all data from database to tab-delimitered textfile
with field headers. Number of fields then seems unlimited.
Best of luck!
Jan Kåre Jøsok
Norway
"Lee" wrote:
Im trying to set up a mail merge document with Word & excel 2007. Is there a
limit on the number of merge fields I can use? My spreadsheet has 200+
columns that are each a merge field. When I try to merge documents, many of
the fields at the end of the spreadsheet arent viewable. Any suggestions
workaround this would be great.
|