on all of my machines I get the following error message:

2282: Das Format, in dem Sie das aktuelle Objekt auszugeben versuchen, ist
nicht verwendbar
I try to translate:

the format, you try to output the actual object, is not available.

This is the code which causes the error.

            DoCmd.SendObject acReport, stDocName, _
                acFormatXLS, _
                IIf(RstAdjust!Email, rst!Email, "mail") _
                , , , _
                strAdressen_Text, _
                strDialog, False

It seems to me that acFormatXLS causes the trouble.

Any ideas?

Regards
Helmut

Regards

Hi Helmut:

I am experiencing the exact problem you are, and I was wondering if
anyone had offered an explanation or solution since you posted last
November.  In some cases, if we don't specify the format, and allow the
selection box of formats to come up, and let the user select Excel, the
problem goes away (as a workaround.)  But in at least one case, I still
get an error.  I have been wondering whether this has to do with what
exchange filters are installed, or not installed, when doing a 'Typical'
Office installation.

--
Posted via http://dbforums.com