E-Mailing a specific page of a report

[Mark]

I have lengthy report that is grouped by Zone ID. I want to e-mail the zone
supervisor the pages of this report as an attachment (in a snapshot format)
that deal with just their zone. currently we e-mail the whole report and the
hunt for their information. The zone supervisor e-mail address is in a table
called 'tblZones'

I don't want to have to create a report with a corresponding query (if
possible) for each zone. I am currently using sendobject to deliver this
report. However we are not always notified of supervisor changes and would
like to use the e-mail addresses from the tblZones as this is always current.

The idea is the end user pushes a button and the report is e-mailed with as
little interaction from the end user as posible. I have built e-mail
messages using table data but nothing like this.

Thanks for your assistance

Mark

 

[Wayne-I-M]

Hi Mark

You need to filter the report to show just the information you need - you
can use the base query for this (an easy answer would be - query by form)

After that use something like this to send the filtered e mail

Private Sub ButtonName_Click()
DoCmd.SendObject acReport, "ReportName", "E Mail format", Forms!Form Name, ,
"", "Title of mail", "Some message here", False, ""
End Sub

Change the names to what they are in your DB