Too many fields

[MikeD]

We are currently working on a project in which we have an
Excel spreadsheet. The field names are currently in column
A and the needed data is in column B. We cannot transpose
the data in one sheet so that it's compatible with mail
merge because there would be over 1500 fields needed, and
Excel only allows 256 fields. Is there a way to do a mail
merge with vertical fields instead of the standard
horizontal fields, or is there a way to merge using
multiple sheets within a workbook, or should we just give
up on mail merge and try to write a macro linking the
needed data with the word document? Thanks for the help

Mike

 

[MikeD]

I forgot to mention, it is in Office 2000. Thanks.

 

[Cindy M -WordMVP-]

Hi MikeD,

We are currently working on a project in which we have an
Excel spreadsheet. The field names are currently in column
A and the needed data is in column B. We cannot transpose
the data in one sheet so that it's compatible with mail
merge because there would be over 1500 fields needed, and
Excel only allows 256 fields. Is there a way to do a mail
merge with vertical fields instead of the standard
horizontal fields, or is there a way to merge using
multiple sheets within a workbook, or should we just give
up on mail merge and try to write a macro linking the
needed data with the word document?

You'll need to go the macro route, I think. Or, possibly,
"transpose" to a character-delimited text file and use that
as the mail merge data source.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail