Not enough fields in Excel for mail merge document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 07 Jun 2004 22:14 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 08 Jun 2004 06:10 GMT

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?

Signature

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

> Hi!
> I use excel as a datasource for a large boilerplate
[quoted text clipped - 7 lines]
> ability. Is there a way to use more than the top row of a
> range in excel for the mergefield data?

Reply to this Message

- 08 Jun 2004 16:28 GMT

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

>-----Original Message-----
>Hi Dave,
[quoted text clipped - 16 lines]
>
>.

Reply to this Message