Re: SendObject - acFormatXLS error

[Tom Geimer]

I have an Access 2000 application that exports a report to
Excel and attaches it to an outlook email prior to sending
it to a distribution list using the command:

Docmd.SendObject acSendReport, "rptTodayReceivingLog",
acFormatXLS

We started testing this feature against Access 2002
(Office XP SP2) and it fails with the following error
message: "Runtime error 2282, The format in which you are
attempting to output the current object is not valid" even
thought the module compiles without errors.

Removing the acFormatXLS from the command line does allow
the code to execute without error, but does trigger the
pop-up window, forcing the user to select the output
format each time.

the acFormatXLS option is used in various other places in
the application (Docmd.OutputTo acOutputQuery....) without
errors.

Online help for the SendObject method shows that
acFormatXLS is a legitimate OutputFormat. Any idea why
this fails in Office XP?

 

[chas]

Hi Tom,

try using the actual value 8 instead of the constant
acFormatXLS

hth

chas

 

[chas]

Hi Tom,

try the following Microsoft article:

http://support.microsoft.com/?id=226526
(ACC: Error Message Using OutputTo to Output a Report to
Another Format)

hth

chas