I'm a VBA rookie having trouble with displaying an email in Outlook for edit before I send it. I have the following code behind a command button on a form. Trouble is, is sends it automatically. Have I gone the wrong way using this approach?
Private Sub cmdAddInfo_Click()
Dim strToWhom As String
Dim strMsgBody As String
Dim strSubject As String
strSubject = "Job Ref. #: " & Me!txtLibrary
strToWhom = "brando@mycompany.com"
strMsgBody = "Insert your comments here."
DoCmd.SendObject , , , strToWhom, , , strSubject, strMsgBody, False
End Sub
Private Sub cmdAddInfo_Click()
Dim strToWhom As String
Dim strMsgBody As String
Dim strSubject As String
strSubject = "Job Ref. #: " & Me!txtLibrary
strToWhom = "brando@mycompany.com"
strMsgBody = "Insert your comments here."
DoCmd.SendObject , , , strToWhom, , , strSubject, strMsgBody, False
End Sub
Last edited: