I am using the DoCmd.SendObject method to automatically send a report by e-mail.

The listed intrinsic output formats are DAP, HTML, RTF, TXT or XLS. Is there a way to send the report as a Snapshot (.SNP) instead? If so, what constant should I use for the output format parameter?

This report is in Access 2000. Is this capability DoCmd.SendObject / Report / Snapshot available in Access 2002 or Access 2003 if it doesn't work with Access 2000?

Rand

__________________
Rand

This is what I use and then call the function:

Function SendSnap()
On Error GoTo SendSnap_Err

    DoCmd.SendObject acReport, "", "SnapshotFormat(*.snp)", "", "", "", "", "", True, ""

SendSnap_Exit:
    Exit Function

SendSnap_Err:
    If Err = 2487 Then
        MsgBox "Please close and reopen report before sending as Snapshot.", , "Reporting Error"
    End If
    Resume SendSnap_Exit

End Function

What out for word wrapping!

Regards,

Beth M

Thanks Beth,

That worked perfectly. I don't know why it wasn't mentioned in the Microsoft Office documentation for the DoCmd.SendObject method.

Rand

Hard telling.. But unfortunately, there's alot that isn't documented I'm glad you got it working!

Regards,

Beth M

Another wonderful undocumented Microsoft feature.

Oy!


Rand

Is there a way to use Docmd.sendobject to send a table or query in CSV format as well?

-Raelz-