send an email via MS-Access 2003

By LarryD4 ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Ah yes

by LarryD4 In reply to See the following site

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.

Collapse -

It doesn't

by BFilmFan In reply to Ah yes

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

Collapse -


by Anud In reply to send an email via MS-Acce ...

Related Discussions

Related Forums