email filtered report

I am looping through a recordset and want to send a snapshot report to each
person in the recordset. The report should be filtered for the current
peopleID but I dont know how to pass the current peopleID to filter the
report before i do a sendObject

Any suggestions please

"judith" wrote in message
...
I am looping through a recordset and want to send a snapshot report to each
person in the recordset. The report should be filtered for the current
peopleID but I dont know how to pass the current peopleID to filter the
report before i do a sendObject

Any suggestions please

Pass the peopleID in the 3rd (WhereCondition) parameter of the OpenReport
method:

DoCmd.OpenReport "report name",,,"[peopleID]=" & recordset![peopleID]

Carl Rapson

I dont think this will work as i dont physically want to open the report, i
just want to use it in the sendObject statement but want the snapshot output
to be filtered

DoCmd.SendObject acSendReport, "individualRenewalEmail",
acFormatSNP, toName, , , toSubject, toMsg

My only idea is to write down the filter field back to the form as i loop
through the dataset and pick up the filtered report from a query using the
form field as a filter. It just seems a bit inefficient

"Carl Rapson" wrote:

"judith" wrote in message
...
I am looping through a recordset and want to send a snapshot report to each
person in the recordset. The report should be filtered for the current
peopleID but I dont know how to pass the current peopleID to filter the
report before i do a sendObject

Any suggestions please

Pass the peopleID in the 3rd (WhereCondition) parameter of the OpenReport
method:

DoCmd.OpenReport "report name",,,"[peopleID]=" & recordset![peopleID]

Carl Rapson

As far as I know, you can't filter a report when using SendObject without
opening the report first.

Carl Rapson

"judith" wrote in message
...
I dont think this will work as i dont physically want to open the report, i
just want to use it in the sendObject statement but want the snapshot
output
to be filtered

DoCmd.SendObject acSendReport, "individualRenewalEmail",
acFormatSNP, toName, , , toSubject, toMsg

My only idea is to write down the filter field back to the form as i loop
through the dataset and pick up the filtered report from a query using the
form field as a filter. It just seems a bit inefficient

"Carl Rapson" wrote:

"judith" wrote in message
...
I am looping through a recordset and want to send a snapshot report to
each
person in the recordset. The report should be filtered for the current
peopleID but I dont know how to pass the current peopleID to filter the
report before i do a sendObject

Any suggestions please

Pass the peopleID in the 3rd (WhereCondition) parameter of the OpenReport
method:

DoCmd.OpenReport "report name",,,"[peopleID]=" & recordset![peopleID]

Carl Rapson