email current record (1 Viewer)

rhay

Registered User.
Local time
Today, 11:52
Joined
Mar 30, 2001
Messages
24
I know how to email an entire report based on my records, but how do I email just one report?

Robert
 

MarionD

Registered User.
Local time
Today, 11:52
Joined
Oct 10, 2000
Messages
421
Hi Robert,

The only way I found to do this is as follows:
I have a form where I select the Person (record) I want to print for (in a combo box). I set up a new report identical to the first that prints for all records. In the query (source) for the second report, iI entered the criteria under the unique ID Field forms![mydialogprintfrm]![mycomboboxselectionID]. That means that when the report is opened from that form it prints only the current selected record.Then I added a command button with the normal E-Mail sendobject......
Works fine for me.
Hope it helps.
Marion
 

Users who are viewing this thread

Top Bottom