P
Pjdelchi
I need to send a report to five or six people usin a macro. The report that
I need to send needs to be filtered for each recipient so that they receive
only the data pertaining to them. Each recipient has their own code in the
query that the report is based on. Is there a way to filter a query in a
macro, send the email, requery the macro, send another email, etc. so that
all emails are sent out? Or do I need to just create 6 different queries
and reports, and then use them in a macro?
I need to send needs to be filtered for each recipient so that they receive
only the data pertaining to them. Each recipient has their own code in the
query that the report is based on. Is there a way to filter a query in a
macro, send the email, requery the macro, send another email, etc. so that
all emails are sent out? Or do I need to just create 6 different queries
and reports, and then use them in a macro?