Storing emails sent from database

[icthus123]

I have a form, which people can use to send emails using CDO. However, I would like the emails sent using it to be stored in a table on the database.

Now I don't particularly want the email form to be a table based form if I can help it. So how can I rig it so that whenever anyone sends an email with the form the message and recipient, etc all get stored in a table? Any ideas?

[mattj]

Use an Append query or open a recordset and use that to update the table. The append query would be the easiest method.

HTH
Matt