Forms snp report.

R

Rpettis31

I am able to print a snap shot report of one record I was wondering if anyone
knew how to code this to send just one record via email?

THanks
 
A

Arvin Meyer [MVP]

Use SendObject in code or just use Send from the File menu. In Code that
would be:

DoCmd.SendObject acSendReport, "YourReportName", acSnapshot, "[email protected]"

This assumes that your report is set to print just 1 record using a where
clause:
 
Top