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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Snap (.snp) file in VBA 1
Somebody tell me WHY? looks good in preview but not in SNP? 2
name of send report 1
always same file-name 3
Password protect Snapshot files? 2
Emailing a SNAPSHOT file via SENDOBJECT 13
Access 2010 Report Button 0
report to PDF format 5

Back
Top