Sending Out Email from Access 2007

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

Guest

Hi everyone, this one has been puzzling me for quite a bit now, and I've
trauled over most of the internet trying to find a solution ;)
I have a form set up that the user enters in an email address, subject, and
then the message, I've set up a button which uses a SendObject command,
however, I can't get it to read the email address, subject, or message text
boxes. Thanks!
 
Ivan Marinkovic said:
Hi everyone, this one has been puzzling me for quite a bit now, and
I've trauled over most of the internet trying to find a solution ;)
I have a form set up that the user enters in an email address,
subject, and then the message, I've set up a button which uses a
SendObject command, however, I can't get it to read the email
address, subject, or message text boxes. Thanks!
Click to expand...

What's the code behind your button?
 
Hi, thanks for the reply, I've actually solved it myself now, but as a
reference for anyone trying to do similar, here is what I put:
Private Sub btnSend_Click()
On Error GoTo Err_btnSend_Click

DoCmd.SendObject acSendNoObject, , , Me.Email_Address, , , Me.Text44,
Me.Text46, EditMessage0
Exit_btnSend_Click:
Exit Sub

Err_btnSend_Click:
MsgBox Err.Description
Resume Exit_btnSend_Click

End Sub
 
Back
Top