Generate email via smtp when adding a record?

[Mick]

We have an access 2003 database we're using to track service requests,
we're trying to figure out if there is a way to have an email sent when
they add a record to the database (generally speaking when they put in
a service request)?

Thanks for any input.

 

[Guest]

First, you have to have an SMTP server accessible. IIS or any other smtp
server will work.
To get the message to the server, I use a small freeware program called
MailSend(http://www.muquit.com/muquit/software/mailsend/mailsend.html).
It takes a bit of work, but you have to build a textfile and a batch file
dynamically in your code and then execute the batch file from code.

If you want a shortcut and are willing to spend money, look here:
http://www.fmsinc.com/products/Emailer/index.asp

HTH,
Barry

 

[Tony Toews]

We have an access 2003 database we're using to track service requests,
we're trying to figure out if there is a way to have an email sent when
they add a record to the database (generally speaking when they put in
a service request)?

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm