By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Report Emailing

P: n/a
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

Aug 10 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <co*******@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

Aug 10 '07 #2

P: n/a

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
Aug 10 '07 #3

P: n/a
If you don't want to muck about with sendobject and Outlook there's a
free utility called vbSendMail that allows you to send smtp email directly.

http://www.freevbcode.com/ShowCode.Asp?ID=109
colemanj4 wrote:
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.googlegr oups.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
Aug 10 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.