Continuation Access Freezes with email is not sent on second iteration
Dear Experts,
This is a follow on question to the one posted here:
https://www.experts-exchan
Seems that when the user attempts to send an email but closes the email dialogue box the first time no problem! This was the initial fix I was looking for. However, if the user (an this happened) attempts to send an email (once and the closes) and then again attempts to send an email then closes the dialogue box again I get the same error and the application freezes.
In fact, the user sends an email successfully then attempts send another one but closes the dialogue box the application freezes. So for whatever reason the error capture works the first time but not subsequent times. In fact, I pressed on the onclick event, then close the mail dialogue box without sending. Then I close the form to see if this would reset things but when I attempted to send another email message but instead closed the mail MS outlook dialogue box the application once again freezes.
I must need to 'reset' something after the first attempt but not certain what that needs to be. Attached are screenshots of the errors I am getting.
When i close the ms outlook dialogue box for the second time
When I try to close the application after the error message
This is a follow on question to the one posted here:
https://www.experts-exchan
Seems that when the user attempts to send an email but closes the email dialogue box the first time no problem! This was the initial fix I was looking for. However, if the user (an this happened) attempts to send an email (once and the closes) and then again attempts to send an email then closes the dialogue box again I get the same error and the application freezes.
In fact, the user sends an email successfully then attempts send another one but closes the dialogue box the application freezes. So for whatever reason the error capture works the first time but not subsequent times. In fact, I pressed on the onclick event, then close the mail dialogue box without sending. Then I close the form to see if this would reset things but when I attempted to send another email message but instead closed the mail MS outlook dialogue box the application once again freezes.
I must need to 'reset' something after the first attempt but not certain what that needs to be. Attached are screenshots of the errors I am getting.
When i close the ms outlook dialogue box for the second time
When I try to close the application after the error message
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I use error trapper like below w/o problems
On Error GoTo SendEmailErr
DoCmd.SendObject , , , sEmail, , , sType & "(s) " & sAppDen & ". (Testing)", s, True
SendEmailExit:
Exit Sub
SendEmailErr:
If Err.Number = 2501 Then
Resume Next
Else
MsgBox Err.Description
Resume SendEmailExit
End If
Yeah....I think I am doing this right. If you look at the link above I used the code provided in the previous discussion block:
And even with I can the error ONLY on the second and subseqent cancellations. If I close the MS Outlook dialogue box the first time the error is trapped and all is good. But if I try it again then the application freezes. There must be a 'reset' somehow so the trapping works over and over again.
Public Sub SendEmail(pName As String)
On Local Error GoTo LocalError
Dim School As String
Dim mailto As String
Dim ccto As String
Dim bccto As String
Dim TeacherName As String
Dim mailsub As String
School = Nz(DLookup("tblSettingsSchool", "tblSettings"), 0)
TeacherName = Nz(DLookup("teacherName", "tblTeacher"), 0)
mailto = Me.studentParentEmail
ccto = ""
bccto = ""
mailsub = "Recent Student Report from " & TeacherName & " at " & School
emailmsg = _
"Hello " & pName & "!" & vbNewLine & vbNewLine & _
"Please find your child's student report from " & TeacherName & " at " & School & " attached!" & vbNewLine & vbNewLine & _
"Thank you!"
DoCmd.SetWarnings (False)
DoCmd.OpenReport "rptStudentReport", acViewPreview, , "[studentID] = '" & [studentID] & "'"
DoCmd.SendObject acSendReport, , acFormatPDF, mailto, ccto, bccto, mailsub, emailmsg, True
DoCmd.Close acReport, "rptStudentReport", acSaveNo
DoCmd.SetWarnings (True)
Exit Sub
ProcExit:
DoCmd.Close acReport, "rptStudentReport", acSaveNo
DoCmd.SetWarnings (True)
Exit Sub
LocalError:
If Err.Number = 2501 Then
Resume Next
Else
MsgBox Err.Description
Resume ProcExit
End If
End Sub
Private Sub cmdEmailParent_Click()
Dim pName As String
pName = InputBox("Enter the parent's name", "SEND EMAIL TO PARENT")
If pName <> vbNullString Then
SendEmail pName
End If
End Sub
And even with I can the error ONLY on the second and subseqent cancellations. If I close the MS Outlook dialogue box the first time the error is trapped and all is good. But if I try it again then the application freezes. There must be a 'reset' somehow so the trapping works over and over again.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial