Record limit with Microsoft Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerrett Conover - 14 Apr 2004 18:44 GMT

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

Reply to this Message

Cindy M -WordMVP- - 15 Apr 2004 16:19 GMT

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
[quoted text clipped - 4 lines]
> 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

:-)

Reply to this Message