Email the current record after update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a data entry form and I am manully updating the values into a table.
The requirement is to email the currently entered record to a set of people
via email basically telling them that a record has been created. How would I
go about it?

Any help would be greatly appreciated.

Thanks,
PS
 
Hi PS,

You can use DoCmd.SendObject to send an email (e.g. after clicking a
button on the form). If you use it to send the form in HTML format, for
instance, it sends a message with an attachment that shows the current
contents of the form. Or use it to "send no object" but include whatever
you want in the body of the message. There are other possibilities too.
 
Back
Top