sendobject Report to Excel?

[Wrathchild]

I recently switched from Access 97 to 2002 and I use to be able to run a macro to spit out a report into excel and email it. Now I keep an error message when I try to do that. Error Message: "The format in which you are attempting to output the current object is not available" Run time error 2282. Real helpful! Any ideas?

 

[MARKNLA2]

TRY THE TRANSFER DATABASE MACRO ACTION WITH EXPORT INSTEAD OF IMPORT WITHIN THE ACTION ARGUEMENTS. THE SENDOBJECT IS THE EMAIL FUNCTION WHILE THE TRANSFER IS THE "SPIT OUT" FUNCTION.