Well, there is about 150 different recipients, each getting an
individualized report (same report, different information from the
query). The query's parameters are Name and Date()-1, which will give
me any new jobs that the person got yesterday. I want to send it out
on a daily basis, but the person should only get one if they have
something new as of yesterday, otherwise it should skip over them. I
know I can do an if statement in VBA saying only if query.size >0 or
something like that. I just don't know how to get it to run through
each person in my employees table (that is also where the email
address is).
Also, what would I use to automate it? Windows Scheduler?
--Jason Coleman
On Aug 10, 2:15 pm, "Len Robichaud" <len.robich...@rqwproserv.com>
wrote:
The simple answer is Yes, it can be done using the SendObject method.
However there are several approaches to doing this with varying degress of
complexity all of which require using VBA.
Do you want to send one report to multiple recipients or does each recipient
get an individualized report?
How many different recipients are there?
Len Robichaud
"colemanj4" <colema...@gmail.comwrote in message
news:11**********************@e9g2000prf.googlegro ups.com...
Hello,
I have a report that takes a person's name and shows any outstanding
jobs that are required of them. People are complaining that they don't
get proper notification when they have jobs open, or that they forget
they have one. So, I was wondering if anyone of you know of a way that
I can automatically make the report run through the Employee table,
and email each employee (address is in the table) the report if they
have any jobs open.
Any help you could provide would be great. If you need more
information let me know.
--Jason Coleman