To send email does it need to be on its own Command Button (1 Viewer)

[patkeaveney]

I have a private sub which i am trying to use to sends emails from a form

At the moment I call the sub from within an ON click event (On add New Button) when a user saves a record,.

Will this work, or does the code to send emails have to be on a button of its own. send email(On Click event).

I have posted the code on another thread,
this is just to find out if i can embed the email code or not.

Thanks

Pat

 

[ted.martin]

A button on its own is best
Private Sub cmdeMail1_Click()
On Error GoTo Err_cmdeMail1_Click
Dim strMail As String
strMail = [e-mail1] ' this is the text box with the e-mail address
cmdeMail1.HyperlinkAddress = "mailto:" + strMail
Exit_cmdeMail1_Click:
Exit Sub

Err_cmdeMail1_Click:
MsgBox Err.Description
Resume Exit_cmdeMail1_Click
End Sub

 

[patkeaveney]

thanks

Would you mind looking at the post below to see where i am going wrong

http://www.access-programmers.co.uk/forums/showthread.php?t=143881&goto=newpost