acFormatXLS is not available

D

Dorci

Access 2002 - I can't email a report in Excel format. The following command
to email the report in Rich Text Format works fine.

===> DoCmd.SendObject acSendReport, stDocName, acFormatRTF, "PET Tooling
Schedule Dist List", , , stMsgSubject, stMsgText, -1

But when I change it to the following command, I get an error message that
the requested format is not available.

===> DoCmd.SendObject acSendReport, stDocName, acFormatXLS, "PET Tooling
Schedule Dist List", , , stMsgSubject, stMsgText, -1

However, when I run the report manually, I can email it using the menu
command. It gives me the option to select Excel, and emails the report
successfully. Why won't the SendObject command accept the acFormatXLS option?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

acFormatXLS Works in 2003 not 2007 1
Change the name of the file attachment using sendobject 0
DoCmd.OutputTo acOutputQuery acFormatXLS to 97-2003 not 2005 2
Module suddenly won't run 7
HTML Email Code 1
Interger for constant acFormatXLS 4
SendObject and excel format 2
Email first report in HTML and second in Excell 2

Top