Email Report

[Froto]

When I open my report based on a query, there are usually
several pages in the report. What I need is the code that
would allow me to email only page 1 or maybe page 6 from
a command button. I have tried several attempts but I
always have the report mailed with all the pages. Any
help would be appreciated.

 

[cjoan75]

Froto,

My first suggestion would be to narrow down the amount o
records(pages) you want to email either using the filter/where functio
of the docmd.openreport. There are various ways of sending the emai
and it sounds like you have that part right.

Henr