How can I email when .... (1 Viewer)

Hello All,
I am using Access 2000. I have a table named tblExport.
The table contains three three fields: Computername, Date, and Time. The table gets populated when a user clicks on the Export button on the front-end. What I would like is when the table tblExport is updated from the front-end when the user clicks on the Export button that it then sends an email. How can I accomplish this? Thank you very much for your help in advance.

Lookup the SendObject command.

It works thusly:

DoCmd.SendObject all the relevant arguments


Also, it's not really a good practive to go calling your fields Date and Time as these are reserved words in Access due to the Date() and Time() functions - they could cause problems in the future.