Not enough fields in Excel for mail merge document

[Dave]

Hi!
I use excel as a datasource for a large boilerplate
document (over 100 pages that are edited beyond mail merge
data) that references the changing data (depending on the
report) at various locations throughout the report.
However, I need more than 256 fields (the number of
columns in excel) and cannot get Word mail merge to
recognize ranges that include header sources on more than
one line. I particularly need excel for its computation
ability. Is there a way to use more than the top row of a
range in excel for the mergefield data?

 

[Doug Robbins - Word MVP]

Hi Dave,

256 is the limit. Can you split the main document into two and use a
different datasource for each half and then recombine the halves after
executing the merge?

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

 

[Guest]

Hi Doug:

Yeah, actually I think since this is the case I will end
up using Binder to keep the document together while still
sectioning it. Thanks very much for your response, I
needed an expert to confirm my observation.

Sincerely,
Dave