problem sending an email with SendObject

  • Thread starter Thread starter Paul James
  • Start date Start date
P

Paul James

I'm trying to send a report using the SendObject method in Access 2002, but
I get the error message

"Microsoft Access can't send this e-mail message."

The strange thing about this is that this procedure had been working well
for several weeks; and even though I haven't made any changes to the VBA
code, I'm getting this error message.

I've been in the knowledge base, and I wasn't able to bring up any papers on
that particular error message. However, I did notice that there were some
articles about other problems related to SendObject, where the cause had
something to do with a security patch. And the solution was to undo the
patch. Is it possible some type of patch could be causing this problem?

I'll reproduce the code below in case anyone wants to look at it, but again,
I can't believe the problem is with the code because it had been working
perfectly well for several weeks:

stDocName = "rptApprovalNotice"
DoCmd.SendObject acReport, stDocName, acFormatRTF,
Forms!frmApprovalNotice!Email, _
Forms!frmApprovalNotice!ccEmail, , "Approval Notice"

Any ideas of what might be causing this error message:

Microsoft Access can't send this e-mail message

Thanks in advance,

Paul
 
I'm trying to send a report using the SendObject method in Access 2002, but
I get the error message

"Microsoft Access can't send this e-mail message."

The strange thing about this is that this procedure had been working well
for several weeks; and even though I haven't made any changes to the VBA
code, I'm getting this error message.

I've been in the knowledge base, and I wasn't able to bring up any papers on
that particular error message. However, I did notice that there were some
articles about other problems related to SendObject, where the cause had
something to do with a security patch. And the solution was to undo the
patch. Is it possible some type of patch could be causing this problem?

I'll reproduce the code below in case anyone wants to look at it, but again,
I can't believe the problem is with the code because it had been working
perfectly well for several weeks:

stDocName = "rptApprovalNotice"
DoCmd.SendObject acReport, stDocName, acFormatRTF,
Forms!frmApprovalNotice!Email, _
Forms!frmApprovalNotice!ccEmail, , "Approval Notice"

Any ideas of what might be causing this error message:

Microsoft Access can't send this e-mail message

Thanks in advance,

Paul
 
Back
Top