Email excel attachment

[crug]

Hi all this is doing my head in. I can transfer my query to Excel ok and i can send a report to Email. But what i want is to be able to attach my query in Excel format and attach it to an Email and send it without any warnings. Any ideas ?

 

[crug]

Any ideas ? pointers ? i can export to excel and i can open outlook from access but i wanna combine those functions

 

[Sergeant]

I haven't done this myself, but it seems you need to:

-Export it to a temp directory in excel format (transferspreadsheet?)
-Attach it to the email (.attachments.add)
-Delete it from temp directory

 

[crug]

That all i think i`ve sorted it