Record limit with Microsoft Excel

[Gerrett Conover]

When creating a mail merge from an Excel spreadsheet, I
notice that I am only shown approximately 200 rows
(records) of the spreadsheet, even though there are many
more rows in the file.

Is there a limit to the number of records returned when
using Excel? Or is there a trick to viewing (choosing)
all the records?

Thanks,

Gerrett

 

[Cindy M -WordMVP-]

Hi Gerrett,

Which version of Office are we discussing, here?

And where are you "viewing" the records/rows? If you
actually execute the merge, do all the records come across?

Note: no, there is no limit to the number of records mail
merge can process to a new document or the printer.

When creating a mail merge from an Excel spreadsheet, I
notice that I am only shown approximately 200 rows
(records) of the spreadsheet, even though there are many
more rows in the file.

Is there a limit to the number of records returned when
using Excel? Or is there a trick to viewing (choosing)
all the records?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
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