email a table

  • Thread starter Thread starter Pat Wright
  • Start date Start date
P

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
 
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-----
Click to expand...
 
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?
Click to expand...

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