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, "(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

Mail Merge skipping records/sending one at a time 0
Send email SNP files? 0
Adding data to MS Access from csv file 0
Please help to email reports in snp files 0
Send meeting request for different dates (no repetition) to different people 0
Somebody tell me WHY? looks good in preview but not in SNP? 2
name of send report 1
Print Snap (.snp) file in VBA 1

Top