I have a multi page report that has employee information on separate pages.
Ex: John Doe, page 1, Jane Doe, Page 2 .. Etc.. I want to be able to email
the page for john doe to john doe, and jane doe to jane doe, with one command
button. I can email the whole report, but can't figure out how to begin to
select individuals. I have done a lot of reading on here, but it's still not
clear. ANy help would be greatly appreciated.

Hi,
you can do the following:
make a new query "MyQuery" based of your report's recordsource
set report's recordsource to this query

open recordset to loop through employees
for each employee create a query based of your report's recordsource, but
filtered by employee (you can use currentdb.querydefs("myquery").sql=...)
send report to current employee using docmd.sendobject

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"sue gray" <(E-Mail Removed)> wrote in message
news:FBEBB107-9B8E-46FE-B021-(E-Mail Removed)...
> I have a multi page report that has employee information on separate
> pages.
> Ex: John Doe, page 1, Jane Doe, Page 2 .. Etc.. I want to be able to
> email
> the page for john doe to john doe, and jane doe to jane doe, with one
> command
> button. I can email the whole report, but can't figure out how to begin
> to
> select individuals. I have done a lot of reading on here, but it's still
> not
> clear. ANy help would be greatly appreciated.

Thanks for the reply. Can you give me more details? I am ok with the first
steps, but don't have any idea how to handle the second paragraph. Thanks.

"Alex Dybenko" wrote:

> Hi,
> you can do the following:
> make a new query "MyQuery" based of your report's recordsource
> set report's recordsource to this query
>
> open recordset to loop through employees
> for each employee create a query based of your report's recordsource, but
> filtered by employee (you can use currentdb.querydefs("myquery").sql=...)
> send report to current employee using docmd.sendobject
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
>
> "sue gray" <(E-Mail Removed)> wrote in message
> news:FBEBB107-9B8E-46FE-B021-(E-Mail Removed)...
> > I have a multi page report that has employee information on separate
> > pages.
> > Ex: John Doe, page 1, Jane Doe, Page 2 .. Etc.. I want to be able to
> > email
> > the page for john doe to john doe, and jane doe to jane doe, with one
> > command
> > button. I can email the whole report, but can't figure out how to begin
> > to
> > select individuals. I have done a lot of reading on here, but it's still
> > not
> > clear. ANy help would be greatly appreciated.
>
>

Hi,
here some air code, hope it explains my idea:

set rst=currentdb.openrecordset("MyQueryWithEmployees",dbopenforwardonly)
do until rst.eof
currentdb.querydefs("myquery").sql="Select .... From .... Where
EmployeeID=" & rst.EmployeeID
docmd.sendobject acSendReport,"MyReport",,rst!Email
rst.movenext
loop

see OpenRecordset Method in access help for details opening recordset


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"sue gray" <(E-Mail Removed)> wrote in message
news:36D5E438-3216-471B-AE08-(E-Mail Removed)...
> Thanks for the reply. Can you give me more details? I am ok with the
> first
> steps, but don't have any idea how to handle the second paragraph.
> Thanks.
>
> "Alex Dybenko" wrote:
>
>> Hi,
>> you can do the following:
>> make a new query "MyQuery" based of your report's recordsource
>> set report's recordsource to this query
>>
>> open recordset to loop through employees
>> for each employee create a query based of your report's recordsource, but
>> filtered by employee (you can use currentdb.querydefs("myquery").sql=...)
>> send report to current employee using docmd.sendobject
>>
>> --
>> Best regards,
>> ___________
>> Alex Dybenko (MVP)
>> http://accessblog.net
>> http://www.PointLtd.com
>>
>>
>> "sue gray" <(E-Mail Removed)> wrote in message
>> news:FBEBB107-9B8E-46FE-B021-(E-Mail Removed)...
>> > I have a multi page report that has employee information on separate
>> > pages.
>> > Ex: John Doe, page 1, Jane Doe, Page 2 .. Etc.. I want to be able to
>> > email
>> > the page for john doe to john doe, and jane doe to jane doe, with one
>> > command
>> > button. I can email the whole report, but can't figure out how to
>> > begin
>> > to
>> > select individuals. I have done a lot of reading on here, but it's
>> > still
>> > not
>> > clear. ANy help would be greatly appreciated.
>>
>>

sue gray <(E-Mail Removed)> wrote:

>I have a multi page report that has employee information on separate pages.
>Ex: John Doe, page 1, Jane Doe, Page 2 .. Etc.. I want to be able to email
>the page for john doe to john doe, and jane doe to jane doe, with one command
>button. I can email the whole report, but can't figure out how to begin to
>select individuals.

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/emai...ttachments.htm


Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/