Discussion Locked

Using Snapshot Viewer

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to know how to progammatically send a report using Snapshot viewer. I know how to use the docmd and how to use the sendobject in a macro. But what I need to know is how to use the docmd and specify a snapshot viewer report verses an excel or html report. What is the file extension, commands , etc ?

2 replies

by melodyj

DoCmd.SendObject acReport, "Report Name", "SnapshotFormat(*.snp)", "to@emailaddress.com", "cc@emailaddress.com", "bcc@emailaddress.com", "subject", "message text", False, "template file"

The False is for edit message - true or false.

Regards,
Melody

This discussion is closed to new replies.