Merge Limits

[Jose Rojas]

I have the Need of Merge a large amount of Documents with Merge & Access as
DataSource, however the DataSource it need to be over 240 + fields, when it
reach the limit of fields it give an error at the time of opening the the
word file. please any help it will be apreciated
Jose

 

[Peter Jamieson]

Your best options are probably:
a. export your data to a format that works (perhaps plain text, but how
workable that is depends on what kinds of data you have - multiline and
nn-ANSI characters can both be hard to handle)
b. write your own "merge" using, e.g., Word VBA to get data from Access
using ADO and insert it in the places you want. Nasty, but if you have a lot
to do and can work with VBA it can be the best option.

 

[Doug Robbins - Word MVP]

Hi Jose,

Another method in addition to those that Peter mentioned would be to split
the main document into two parts and merge each part separately and then use
a macro to combine the corresponding sections of the two documents together
into a third document.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Jose Rojas]

I guess the best Option is to use the merge system for 200 or so fields and
the rest write some code that it will load the rest of the document. thanks
for your help
Jose