Periodic Problem

[jameshall]

Hello

My problem is the code below that writes a report to the c:

DoCmd.OutputTo acReport, "rptEmail", "SnapshotFormat(*.snp)", _
RptAddress, False, ""



Every so often (now) it fails to produce the report thus making it jump out of the module and skipping over some more code (to send an Email via a function call)

Does anyone spot the problem or have experienced this before, it has been going on for sometime!

Regards

jameshall

 

[JohnLowell]

This is what I have used and never had a problem:

DoCmd.OutputTo acOutputReport, "rptEmail", "Snapshot Format", RptAddress

 

[jameshall]

Thanks John

I'll change the code to that, i hope it puts that problem to rest.

regards

jameshall