email

[JeffH]

I would like to enter an email address in a field in my database. Then, as I
look at the record on screen, I would like to have the ability to send an
email to the address shown. I would like to be able to enter a custom
message, send the email interactively, and then return to the database record
on screen much like a call routine. Is that possible? If so, how would I do
it?

 

[Rick Brandt]

I would like to enter an email address in a field in my database.
Then, as I look at the record on screen, I would like to have the
ability to send an email to the address shown. I would like to be
able to enter a custom message, send the email interactively, and
then return to the database record on screen much like a call
routine. Is that possible? If so, how would I do it?

Look in help for SendObject() function.

 

[Daniel]

Take a look at
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#email
the email sample database it should get you off to a good start. Depending
on the complexity... you could also use a simpler method using the
Docmd.SendObject method (look it up in the help file for an example).

If you search this site or Google "MS Access vba sending emails" you should
get a ton of examples.