Good day,
I have a pretty good idea how to do this but I am having some problems with the nitty gritty stuff.
I have a query that sorts out which records I want to email.
I have a report that is tied to the query.
As it stands now, the report shows all of the records based on this query. What I would like to do is send a seperate email for each record.
Don't have a lot of experience with reports and would need some assistance as to where to put the code to piece this together.
I'm thinking something along the lines of
Do until rs.EOF
<<sendobject...>>
loop
but I'm not sure..
Many thanks, Al
I have a pretty good idea how to do this but I am having some problems with the nitty gritty stuff.
I have a query that sorts out which records I want to email.
I have a report that is tied to the query.
As it stands now, the report shows all of the records based on this query. What I would like to do is send a seperate email for each record.
Don't have a lot of experience with reports and would need some assistance as to where to put the code to piece this together.
I'm thinking something along the lines of
Do until rs.EOF
<<sendobject...>>
loop
but I'm not sure..
Many thanks, Al