[AccessD] Send filtered report

I was just trying to do a one click automation for the person who will be
sending out different filters of the reports each week. So they wouldn't
have to do anything other than pick the report, pick the filter and click on
"E-mail".
But I guess what I want to do is not as easy as I thought so I may just do
as you suggest.
Thanks,
Nancy

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Wortz, Charles
Sent: Friday, April 25, 2003 8:50 AM
To: accessd at databaseadvisors.com
Subject: RE: [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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com