• Subject: Send Email using SendObject fails when sending more than one time.
  • Author: robboll
  • Date: 21 Dec 2009
  • References:
Hello! The routine below works great when I send only one email. But
when
I send another email, I have to kill Outlook via Task Manager where it
is
immediately replaced by another session of Outlook and Outlooks again
comes up.

Any help with this greatly appreciated!

Rbollinger

=========================================================
Sub Send SendEmail()

On Error GoTo Err_Command11_Click

Dim stDocName, mTO, mCC, mSubject As String

stDocName = "frmSnapShot"
mTO = Forms!frmEmail!emailTO
mCC = Forms!frmEmail!emailCC
mSubject = Forms!frmEmail!Subject
mpath = Mid(Forms!frmIssues!FolderPath, InStr(1, Nz(Forms!
frmIssues!FolderPath), "#") + 1, 100)

DoCmd.SendObject acReport, stDocName, , mTO, mCC, , mSubject, IIf
(Forms!frmEmail!Check3 = -1, "Shared Directory:" & vbCrLf & mpath,
""), , False


Exit_Command11_Click:
Exit Sub

Err_Command11_Click:
MsgBox Err.Description

Exit Sub
email_error:
MsgBox "An error was encountered." & vbCrLf & "The error message is: "
& Err.Description
Resume Error_out
Error_out:


End Sub
21 Dec 2009Send Email using SendObject fails when sending more than one time..robboll
22 Dec 2009\ Re: Send Email using SendObject fails when sending more than one time..Ken Slovak - [MVP - O...
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)