email a table

[Pat Wright]

I have a db with one table and one form. I would like to
be able to have the user be able to click on one button
and email me the table. Does someone have code for this?

Thank you,

Pat Wright

 

[Pat Wright]

I knew that! (I think)

But I am just trying to collect data from various loan
agents to put into one database. So I don't mind if the
data is exported to txt or Excel, just so I can reimport
it.

Thanks again

Pat

-----Original Mesage-----

 

[John Vinson]

I have a db with one table and one form. I would like to
be able to have the user be able to click on one button
and email me the table. Does someone have code for this?

You could use some VBA code using the TransferSpreadsheet method to
export the data to Excel, and mail the spreadsheet.