E-mail Alert

[Josh]

Hello, I'm setting up a request system at work and I would
like my Access Program to send an e-mail to me whenever
someone has sent me a request. The E-mail would be the
same thing each time, just something simple like "A new
request has been sent to you" or something to that
affect. When the user submits the report I have them
click a button to submit it, so perhaps code could be
added to that button that sends an email? Just a though.
I would appreciate any ideas I can get as soon as I can
get them because this project needs to be done as soon as
possible. Thanks.

 

[Douglas J. Steele]

See whether you can find anything applicable in the Microsoft Access Email
FAQ Tony Toews has at http://www.granite.ab.ca/access/email.htm

 

[Lauri]

I use the macro action SendObject. You can set the e-mail address and
message. Have the macro run (or use VB equivalent) when the request is
submitted.

-Lauri