Command Button to Email a Table as an Attachment

[missmis44]

I want to create a command button that when it is clicked it first runs my make query. Then brings up Outlook with that table as an attachment so that my user can enter the appropriate email addresses and send the email. Anyone have any ideas????

 

[PWise]

create a form with a text box and a command button
in the command button on click event
docmd.openquery "yourmaketablequery"
docmd.sendobject "tablename" ,acformatxls,me.textbox
enter a emailaddress in the text box and your table will sent as a excell file to email address of text box