Hello.
I don't know Access VBA (I just know Excel) so I need help please. I added a button with the below code. This button brings up an email in Outlook with the specified info below plus the txtsuggest as the body of the email. The txtsuggest is just a text box on Access where the user can type whatever they want to send. Right now everything works fine, however, I want Access to send the email automatically after the user types the stuff into the text box. Currently, it just brings up the email window with all of the necessary info and forces the user to hit the "send" button on the email. How can I get it to auto send?

Thanks!!!



Private Sub Command2_Click()
On Error GoTo Err_Command2_Click



DoCmd.SendObject acSendNoObject, , , "Person's email", , , " Custody Fund Database Comment/Suggestion", txtsuggest


Exit_Command2_Click:
Exit Sub

Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click

End Sub