emailing a report of a single record

  • Thread starter Thread starter Toph
  • Start date Start date
T

Toph

Can anyone let me know how to (or where to find the info)
email a report of a single record. I am able to print and
email a report of a the whole database, but not a single
record.

Any thoughts?

Thanks.

Toph.
 
You could click on the W on the button bar and save it as a Word document
and then email the Word document.
 
There are a number of ways.
Create the report off a query that prompts you for the
record ID
or
Create the report off a query that get the record ID from
an open form.

Jim
 
I use the following code to email report using the
snapshot viewer. This opens Outlook and attached a
snapshot file to be sent. Others will need the snapshot
viewer to open file.

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "rptNAME", acPreview, "", "[ORDERNO]=
[Forms]![ORDERS]![ORDERNO]"
DoCmd.SendObject acReport, "rptNAME", "SnapshotFormat
(*.snp)", "", "", "", "", "", False, ""

HTH,
Sharon
 
Back
Top