send e-mail from database

[Dyfi Active]

I have a database with an e-mail contact field.
How do I send e-mails using the data in the field for email address?

 

[Rick A.B.]

I have a database with an e-mail contact field.
How do I send e-mails using the data in the field for email address?

If you just want to click a button on your form and have an e-mail pop
up with the users e-mail address already populated then put something
like this behind the button on your form in the on click event.

Private Sub cmdEmail_Click()
Dim strEmail As String

strEmail = "mailto: " & Me.youremailtextbox

Application.FollowHyperlink strEmail

End Sub

 

[aaron_kempf]

SQL Server supports doing this in one place.

From the db Server-- where it belongs.
This way; it is quite easy to keep track of who you are sending what.

This is actually a _VERY_ common requirement for anti-spam purposes.

-Aaron

 

[Gina Whipp]

Outlook? Exchange? Lotus Notes? There are a ton of samples but you have to
help us out a bit! Please ignore Aaron... his answer for EVERYTHING is SQL
Server!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

SQL Server supports doing this in one place.

From the db Server-- where it belongs.
This way; it is quite easy to keep track of who you are sending what.

This is actually a _VERY_ common requirement for anti-spam purposes.

-Aaron

 

[Tony Toews [MVP]]

I have a database with an e-mail contact field.
How do I send e-mails using the data in the field for email address?

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/