Macro-Send Objects-Excel Record Limit

[syoung7903]

I have a macro that contains a line with Send Object. It is emailing the results of a select query to a co worker. It needs to be in Excel format. However it is over 16,500 records and the Macro keeps halting because of the default to Excel version 5 where 16,500 records was over the limit.

Any solutions that you guys could share with me.

Thanks,
Suzanne

 

[Mike375]

Perhaps you could make two queries where each query picks up half of your table and do it with two Excel files. You could use the autonumber field as a reference for your query if you have one. So one query is >=8500 and the other is <8500 etc.

Mike