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