emailing a report of a single record

[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.

 

[Access]

You could click on the W on the button bar and save it as a Word document
and then email the Word document.

 

[Jim/Chris]

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

 

[SHARON]

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