473,320 Members | 1,746 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Report Emailing

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
3 1649
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

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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Nicola | last post by:
Hi Everyone, I am new to programming and would like to know how to open an access Report from within vb 6. I am trying to write a program to organise cross stitch threads. I have found out how...
1
by: Bill | last post by:
Using A2K. Is it possible to email separate pages of a report to separate recipients? I am generating a student report for 500 individual students which I have usually printed off, one page per...
3
by: Prakash Wadhwani | last post by:
Hi !! I have been browsing around but have not been able to find a simple, lucid solution ... or maybe I'm just too confused. I know this has been asked before by many ... but pls bear with me. ...
2
by: Will | last post by:
I am trying to send a report by email using DoCmd.SendObject acSendReport. When I send the report, it sends the report with all the records whereas I only want the report to show one record. I...
6
by: Salad | last post by:
Hi: I have a Bill of Lading template from the printer that I saved as a BMP. I created a new report and in the report's picture property told it the BMP file name. It brought the image in just...
5
by: jmar | last post by:
I posted a week ago and received one response. I'm looking for the opinion of several experienced .NET people before I proceed so I'm posting again. Sorry for the repost... I am updating a...
1
by: crisostomofred | last post by:
I have a report with it's source from a query. The query calls data from 3 related tables. The report is a meeting agenda and I only want to attach a snapshot report to my email based on the...
5
by: AMBLY | last post by:
Hi everyone! Could someone help me with this, please? I run Access2000 on XP Have created a Report. Have placed a button on a form to email the report Works fine - email is generated, ready...
1
by: didacticone | last post by:
i have a database where i am trying to email a report as an attachment, it works fine but since it is an .rtf file the conversion is messy... i was wondering if i can do it as a pdf or some other...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.