Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sending Email electronically

Status
Not open for further replies.

jalenben1

Programmer
Jul 22, 2008
154
US
I am trying to send email from a form electronically. I have a command button called Email this report and I want to send the report to someone. I have the following script:

Private Sub Email_ECM_Report_DblClick(Cancel As Integer)
On Error Resume Next

Dim strToWhom As String
Dim strMsgBody As String
strToWhom = InputBox("john.doe@playdoh.com")
strToMsgBody = "Attached is the Enterprise Change Management Report. If you have any questions, please contact Randall Dameron at randall.dameron@cox.com"

DoCmd.SendObject , , , strToWhom, , , strMsgBox, True


End Sub

Is this the right code?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top