SendObject

[Angie]

I have a SendObject macro set up to send a query as an
Excel file via Outlook. I use this all the time. But I
have a file that is 32,290 records long, and I'm getting
an error back that reads "There are too many rows to
output, based on the limitation specified by the output
format or by Microsoft Access" Can I get around this? I
really need it to be in a macro and automatically done on
the switchboard. HELP!

 

[Van T. Dinh]

Depending on your Access version, which can use one of the earlier Excel
file format which can only take 16K rows. This is most likely the problem
here.

For example, with the TransferSpreadsheet Method (in VBA) in A2K, the
default Excel file format is acSpreadsheetTypeExcel3 which is Excel 3.0 (I
think).

Try the SendObject Method in VBA and see if the FindObject Method uses a
later version of Excel which can take more than 16K rows.