SendObject To Excel Format Access 97

[christyh]

I am trying to create macro to email a query (or table).
Macro uses SendObject Action - Ouput Format is .xls

Receive error "There are too many rows to output, based on
the limitation specified by the output format or by
Microsoft Access."

The query has about 28,000 records. Is that REALLY too
large for spreadsheet? The SendObject action works ok if
Output Format is .txt.

Must I use TransferSpreadsheet option? I want to use
SendObject to help user automate the emailing of this list.

 

[John Nurick]

Hi Christy,

As far as I know SendObject still uses the old Excel 5.0/95 file format
which has a limit of 16384 rows, and only TransferSpreadsheet allows you
to specify Excel 97 or later format and export up to 65536 rows.