Sending Out Email from Access 2007

[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!

 

[Dirk Goldgar]

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!

What's the code behind your button?

 

[Guest]

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