I'm a newbie at Access VBA so please bear with me.

I'm trying to send a table resulting from a query as an Excel attachment. I'm using the SendObject method and works fine until the records it's sending is more than 16,000 records (which I think is the limit for Excel 95). I'm currently running on Access 97.

Why does the attachment get sent in Excel 95 format when I'm running Excel 97? Is there any way to make it send in 97 format?