Help Resolving Error 2293 1

[HiBoo]

I'm trying to send by e-mail a query result. I'm using the following code but keep getting an error. Any advise on what I can do to resolve the problem.

All declarations are complete...

DoCmd.SendObject acSendQuery, "qry_EMail_Changes", acFormatXLS, strEMailAddress, , , "CFA Change Update", strMessageText, False

The Error Message I get is...
"Microsoft Access can't send a message for the reason stated in the preceding alert.

Resolve that problem, and then send the message again."


I know that the query works fine. From the database window though I can't even use the 'Send To' option as an EXCEL attachment as I'll get the same error!

Any thoughts as to why this is occuring and how I might resolve the problem???

Thanks for any help!

 

[nomus1]

By any chance is the query coming from a table that has an ODBC Link?

I have found it necessary to create a temporary table with the data and then export it because the program appears to time out on some of these querries.

 

[HiBoo]

The query comes from a local table. Time is not a factor because there is only one row of data.

 

[tlbroadbent]

Check one the following MS Knowledgebase articles.

Access 97:

http://support.microsoft.com/support/kb/articles/Q262/9/97.ASP

Access 2000:

http://support.microsoft.com/support/kb/articles/Q263/0/84.ASP

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.