Export query as Excel email attachment

[ellenr]

I have a button that exports a query as an Excel file and lets the user browse to the location to save to on their computer. Is it possible with one click of a button to open the email "send to" and send it as an attachment in one step? It works just fine as it is, but the user is only saving it in order to be able to attach it to an email. Just thought it would be slicker to do it in one operation if possible, and haven't been able to find suggestions as to how to do it.

Thanks for you help.

 

[Ranman256]

Docmd.SendTo

(In a macro,or vb)

 

[ellenr]

I still can't figure out how to do this in a query or in vba. All I have is a query that has to be sent to a recipient as an Excel file.

 

[Ranman256]

Create a macro,
In the actions, choose SENDTO.
In the details, enter your query,and email, etc.

 

[ellenr]

Ranman256, I finally found it--SendTo isn't in the action list, but EmailDatabaseObject is, and it did exactly what I needed!
Thank you.