Run-time error 2282 when using DoCmd.SendObject

  • Thread starter Thread starter TC
  • Start date Start date
T

TC

An MS support person answered a similar question some time ago:

"When using SendObject method in Access 2002 to e-mail a report as an Excel
file use one of the constants listed below for the Format argument instead
of the acFormatXLS:
5 for XL97 and earlier
8 for XL2000 or XL2002"

Does that help?

TC


Ginger123 said:
I am getting run time error 2282 when using DoCmd.SendObject in the following:

Dim stDocName As String
stDocName = "rptReport1"
DoCmd.SendObject acReport, stDocName, acFormatXLS,
Click to expand...
"(e-mail address removed)", , , "Report 1"
The error message that appears is the following:

The format in which you are attempting to output the current object is not
Click to expand...
available. This message does not appear for other formats such as
acFormatRTF, acFormatTXT, acFormatHTML. But, it appears for acFormatXLS.
How can I fix this problem?
 
I am getting run time error 2282 when using DoCmd.SendObject in the following:

Dim stDocName As String
stDocName = "rptReport1"
DoCmd.SendObject acReport, stDocName, acFormatXLS, "(e-mail address removed)", , , "Report 1"

The error message that appears is the following:

The format in which you are attempting to output the current object is not available. This message does not appear for other formats such as acFormatRTF, acFormatTXT, acFormatHTML. But, it appears for acFormatXLS. How can I fix this problem?
 
Back
Top