Forms snp report.

  • Thread starter Thread starter Rpettis31
  • Start date Start date
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
 
Use SendObject in code or just use Send from the File menu. In Code that
would be:

DoCmd.SendObject acSendReport, "YourReportName", acSnapshot, "(e-mail address removed)"

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