What is the maximum number of merge fields allowed in a template?

[Schardenzar]

Does anyone know the maximum number fo merge fields allowed in a merge
template for Word 2003?

 

[Doug Robbins - Word MVP]

It will probably be dictated by the datasource - about 63 if it's a Word
document, 255 if it's an Excel Spreadsheet or Table in Access. Possibly no
limit with a text file as the data source.

--
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

 

[Schardenzar]

Thanks! It is a text file and I believe the limit was 255 fields in Word
2000 and prior. We create a text file of fields - just thought the limit was
a hard one (like 256, 512, 1024 etc). The tables we access are SQL 2000/2005
but we write the data to a delimited text file, then do the merge.

 

[Peter Jamieson]

With luck you won't encounter any problems, but FWIW, there have been
reports of new limits imposed in Word 2002, but it has always been difficult
to pin down what they are.

One issue is the connection method used - with text files in Word 2000, Word
would either use its internal text converter or ODBC, partly depending on
what is installed on the user's system. In Word 2002, Word might well use an
OLEDB method which may have a 255 limit.

Another issue may be the size and "complexity" of the data. When Word
connects to text data these days, it /may/ try to detect the text encoding.
I think it probably uses standard WIN32 routines to do that, and they use
various heuristics which (by the nature of heuristics) do not always get it
right. You may find an encoding dialog popping up in some cases. There's an
article about that at

http://support.microsoft.com/kb/290981/

Peter Jamieson