send e-mail from database

D

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?
 
R

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?
Click to expand...

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
 
A

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
 
G

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
 
T

Tony Toews [MVP]

Dyfi Active said:
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?
Click to expand...

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/
 
Top