[AccessD] Send filtered report

Nancy Lytle nancy.lytle at auatac.com
Fri Apr 25 05:57:09 CDT 2003


I am using a form that lets users pick how to filter a report.  As it is now
the user can preview the report or print it, but I would like to add the
ability to email the filtered report.  However instead of sending the
filtered report it sends the whole thing.

DoCmd.OpenReport strReportName, , , strWhere
is what is used to open the report
and
DoCmd.SendObject acReport, strReportName, acFormatRTF,
"nancy.lytle at auatac.com", , -1, "Weekly En Route Rpt"
is used to send it.

So what I would like is similiar to:

DoCmd.SendObject acReport, strReportName(strWhere), acFormatRTF,
"nancy.lytle at auatac.com", , -1, "Weekly En Route Rpt"

Any ideas how to accomplish this?

N Lytle



More information about the AccessD mailing list