Networks

Ask something
Question Locked

send an email via MS-Access 2003

0 helpful
5 replies

by larryd4

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Ok so here is my current task.

I want to let the MS-Access DB email a user when an update is done to a record. Basically, when HR updates or adds a record, IT needs to get heads up in the form of an email to a specific person.

I have accomplished this with a VBA that binds to the shell and then does a objShell.Run command for the small DOS bases "sendsmtp.exe" app.

What I'm trying to find out is if Access has any similar interface that allows you to directly send mail to a SMTP server, rather then have to use the above app.

5 replies

by bfilmfan

http://www.blueclaw-db.com/access_email_send_outlook.htm

by larryd4

But this actually uses outlook to send and we don't use outlook.

I have a command line tool to send just about any email via our SMTP server. But I wanted to see if anyone knew if Access had any built in features to send mail rather then Shell to an outside app.

by bfilmfan

It doesn't have a SMTP engine in the product.

This discussion is closed to new replies.