[AccessD] Send filtered report

Nancy,

How about saving the filtered report under another name and then
e-mailing that version of the report?

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Nancy Lytle [mailto:nancy.lytle at auatac.com] 
Sent: Friday 2003 Apr 25 05:57
To: Accessd
Subject: [AccessD] Send filtered report

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