DoCmd Problem

[A real begineer]

Function DCHL()

stDocName = "rptDynamicChl"
I have the following code through my application, the save to A drive works well for the first five reports. The last report is 50 pages or more in length, and I receive an error. There is no mention of a limit on size in an XLS output to format on the help file. Is this caused by the format or is there some other aspect of the command I do not know?

The email attachemant part of the code ran fine for the first call, however, subsequent calls have failed to run this line. Should I seperate the email out to another function or is there an error in this code?


DoCmd.OutputTo acReport, stDocName, acFormatXLS, "A:\Temp", True

DoCmd.SendObject acSendReport, stDocName, acFormatXLS, "email here", , , "Month", "Here is the monthly data"

 

[simongallop]

Are you sure that you floppy disk isn't full?

 

[Atomic Shrimp]

I'm sure I've heard of a bug (or perhaps just a limitation) regarding the number of rows that can be exported to XLS format....

I'll see if I can find anything on it.

Mike

 

[A real begineer]

No my floppy disk is not full I can check this by the run hust before which is 48 pages, this takes around 14 kB. My real problem is that once it is saved on the floppy I then need to be able to reimport it into my machine.

 

[A real begineer]

I solved the problems thanks guys. Apparently if I send the table I am limited to 50 records only. If I send the table instead I can send 300 records (tested so far).