send report to e-mail

[Guest]

I would like to open a report and then view it before sending it to e-mail.
Here is the code I have it opens the report but sends the report straight to
e-mail. How can I change the code to view the report first and then send it
to e-mail.


DoCmd.OpenReport "rptReferralForm", acPreview, , "[applicant ID] = " &
[applicant ID]
DoCmd.SendObject acSendReport, "rptReferralForm", acFormatSNP, ""

 

[Rick B]

View it and then send it? What would you do to indicate that you were
finished viewing and ready to send? These are two different tasks and you
would have to tell access when to do them.

I would view the report to make sure it was correct, close it, then use the
code you posted to email it.

You could add code to the report that would fire when you close it, but then
it would always email the report when you closed it.

Sounds like two separate functions to me.

Rick B