send current record to snapshot viewer with macro

  • Thread starter Thread starter jv
  • Start date Start date
J

jv

I have a command button that previews a report and
displays only the current record. I would like to add a
macro to send this directly to Outlook with the
attachment of the report. However, I don't know how to
send the current record through the macro. Any help is
appreciated...thanks.
 
Hi JV,

Macro should look like this:

SendObject
Reports
(set options on the macro as required - this is a very flexible tool.)

You'll be sending the report you are previewing which is, by your
description, already filtered to the current record.

hth

Judi B
 
Back
Top