Email the current record after update

P

PS

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
 
J

John Nurick

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.
 
Top