Does anybody have the same problem?
I have an Access database that allows the user to send out information by e-mail using Lotus Notes. When a user clicks on the send button, Lotus Notes appears with the e-mail that is going to be send out opened and ready to be send.
Now, when the user returns to the database and want to send out another e-mail the button doesn't work any longer. It hangs and lotus notes will no longer appear. The user will have to close the database, reopen it and then click send again. This is a huge hassle and would love to know if this can be fixed. Thanks!
Code I used is this:
Private Sub btn_send_Click()
On Error GoTo Err_btn_send_Click
Dim stBody As String
stBody = "test"
DoCmd.SendObject acSendNoObject, , , "xxx@xxx.com", , , "testing", stBody
Exit_btn_send_Click:
Exit Sub
Err_btn_send_Click:
MsgBox Err.Description
Resume Exit_btn_send_Click
End Sub
I have an Access database that allows the user to send out information by e-mail using Lotus Notes. When a user clicks on the send button, Lotus Notes appears with the e-mail that is going to be send out opened and ready to be send.
Now, when the user returns to the database and want to send out another e-mail the button doesn't work any longer. It hangs and lotus notes will no longer appear. The user will have to close the database, reopen it and then click send again. This is a huge hassle and would love to know if this can be fixed. Thanks!
Code I used is this:
Private Sub btn_send_Click()
On Error GoTo Err_btn_send_Click
Dim stBody As String
stBody = "test"
DoCmd.SendObject acSendNoObject, , , "xxx@xxx.com", , , "testing", stBody
Exit_btn_send_Click:
Exit Sub
Err_btn_send_Click:
MsgBox Err.Description
Resume Exit_btn_send_Click
End Sub