How can I add sending an email to a button click

[Starrizzo]

I have a form that submits a new record to an Access DB, is therre a way that I can add a macro that after form close it sends me an email stating there has been a change?

 

[Andrzejek]

Sure, you can take a look at my replay here:

http://www.tek-tips.com/viewthread.cfm?qid=1394046

Have fun.

---- Andy

 

[Starrizzo]

Ok I am a little confused. Im really new to this, but I think i understand the beginning of the code. but when it gets to the server part I am completely stumped.

 

[PHV]

Have a look at the DoCmd.SendObject method

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886