Web Development

Ask something
Discussion Locked

Email from Access 97

0 helpful
3 replies

by bob sellman

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'd like to be able to send email directly from Access 97. I want to pass the subject and body text from Access directly to the email by just selecting the email address, message subject, and body text in Access and then clicking on a button which would then send the email automatically. I assume an ActiveX control may be needed. If so, are there any goods ones that are free (or almost free)? I don't need the detailed code, just what functions and/or controls are needed.

3 replies

by timfox

Hi Bob
Check out this site:
http://www.granite.ab.ca/access/email.htm

It was recommended by another TR member ages ago and has helped me to add a huge amount of messaging and email functionality to MS Access DBs. I have only had to use the LN R5 code, but have every reason to believe that the other references will be just as useful.

Hope it helps.

(I'm still interested in other TR posts for cheap ActiveX controls that assist with managing email, but incorporating mail management within an Access app is (to me) like hitting a nail with a chisel, rather than using the hammer on the bench.)

This discussion is closed to new replies.