Export File to excel then attach to an email

[GarageFlower]

I have searched for this and have not come up with an answer as yet.

I have query that is accessed by entering criteria in a text box and then the user can click a button which will use the criteria entered in the query and then export it to an excel file.

Is there any way i can get the option to export the file and then open up a new email and attach the excel file

 

[reclusivemonkey]

DoCmd.SendObject is what you need. The VBA help will tell you how to use it.