Emailing a report from Access 2000

[Mike Bennett]

I'm using Access 2000.

I need to allow a user to email a report. I've determined
the best method is to email a snapshot of that report
since the recipient will not update the report. However, I
am not able to put a command button on the report (one
that works when the report is viewed, anyway).

What is the best way to do this from Access VBA?

Thanks!
Mike

 

[Terry]

Mike,

How about a button on the form that you call the report
from? One button to preview / print the report and another
to create a snapshot and open an email.

HTH,

Terry

 

[Terry]

Mike,

How about a button on the form that you call the report
from? One button to preview / print the report and another
to create a snapshot and open an email.

HTH,

Terry

 

[Mike Bennett]

Terry,

Thanks. Actually, I made good progress after posting my
question. But, I'm stuck again.

The query that my report is based on is parameterized.
When the user opens the form, the parameters for the query
are requested then filled in by the user. I want to fully
automate the sending of the report such that when the user
presses my "Send Mail" button they don't have to answer
any more questions.

Right now, when the button is pressed, the report begins
to open and prompts the user for the parameters. I would
like to pass the parameters to the report in some way. I
tried assigning directly to "Me.recordset" in the
report_open method, but the error message says that this
is not allowed in an MDB.

I appreciate any help related to this.

Thanks again!
Mike