access mailing list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

can i send mail from access. i have made database with contacts and email
info. can i list opp some of the contacts, and send them an email direct from
access, and howe do i do that. can any one help me. I just startded using
access
 
tiljar said:
can i send mail from access. i have made database with contacts and email
info. can i list opp some of the contacts, and send them an email direct
from
access, and howe do i do that. can any one help me. I just startded using
access
Click to expand...


Access (and other Office apps) can use hyperlinks to browse to a web page
and/or send a msg to an email address.

Create a command button and/or use the Dbl-Click event of the email control
to fire the code below (or something like it):

'======================================
Private Sub email_Click()
If IsNull() Then
MsgBox " No address found ! ", vbExclamation, "Missing e-mail"
Else
On Error Resume Next
DoCmd.SendObject , , , Me![Email], , , "Reston Bike Club"
End If

If Err.Number = 2501 Then
MsgBox " Email message cancelled ", vbExclamation
End If

Exit_Email_Click:
Exit Sub

Err_Email_Click:
MsgBox Error$
Resume Exit_Email_Click

End Sub
'========================================

-Ed
 
Back
Top