473,586 Members | 2,681 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

send report by email

11 New Member
Hi Everyone,
i have to develpe a report which give candidate time sheet entry detail as well
missing time sheet detail After that i have to send this report to every
candidate by mail having its own data.I am a new in this field so pz help me.



Thanks and regards
esha
Feb 9 '08 #1
7 6195
amitpatel66
2,367 Recognized Expert Top Contributor
Hi Everyone,
i have to develpe a report which give candidate time sheet entry detail as well
missing time sheet detail After that i have to send this report to every
candidate by mail having its own data.I am a new in this field so pz help me.



Thanks and regards
esha
WHat are the tools you are using to create a report?
Report builder or any other tool?
Feb 10 '08 #2
subashsavji
93 New Member
Hi Everyone,
i have to develpe a report which give candidate time sheet entry detail as well
missing time sheet detail After that i have to send this report to every
candidate by mail having its own data.I am a new in this field so pz help me.



Thanks and regards
esha
if you are using report 6i then use report 'letter format' or 'mail format'. any one of them will help you to saolve the problem.
Feb 11 '08 #3
ESHA1
11 New Member
WHat are the tools you are using to create a report?
Report builder or any other tool?
I am using report builder and i have to register this report in oracle apps.
Feb 13 '08 #4
ESHA1
11 New Member
if you are using report 6i then use report 'letter format' or 'mail format'. any one of them will help you to saolve the problem.
i am using repoer builder6i and i have to register this report in oracle apps.
Feb 13 '08 #5
amitpatel66
2,367 Recognized Expert Top Contributor
I am using report builder and i have to register this report in oracle apps.
Here would be your work around:

1. Create a report using reports builder that display student information by taking student ID and student email address as input parameter
2. Design the layout as you want to display the information
3. Once the report is run, in the after report trigger , write a pl/sql code that will send email of the output of the report to a email address that is passed as input parameter in step 1.
4. make use of UTL_SMTP for implementing mail functionality

let us know in case of any issues!!
Feb 13 '08 #6
subashsavji
93 New Member
i am using repoer builder6i and i have to register this report in oracle apps.
for registration of report in 11i apps , you must have 11i molude named as 'AOL'
application object library. through which you can register forms and through which reports. but this is the part of 11i apps. you must know use of AOL 11i apps module. and it is process we have to follow.
Feb 13 '08 #7
subashsavji
93 New Member
Hi Everyone,
i have to develpe a report which give candidate time sheet entry detail as well
missing time sheet detail After that i have to send this report to every
candidate by mail having its own data.I am a new in this field so pz help me.



Thanks and regards
esha
if you want to send the report directly on net from form. so it is possible.
but coding of this process is very long. i can not paste here.

another in report builder having option Mail to send report to anyone.
Feb 13 '08 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

1
1363
by: Johnny Gee | last post by:
Hi All I have a macro that I use to send three reports every week to about 10 people by email via Lotus Notes.I use the "Send To" command to send the reports out in Rich Text Format. I used RTF because it was the most compatible way for everybody to open the report. For reasons unknown to me, one of the reports changed "itself" to .xls...
1
6281
by: michi | last post by:
Hi there.... Got here a tricky thing with my SMTP. First I show you what works on my machine.. **This Works** SmtpMail.SmtpServer = "mail.gmx.net" <-gmx is my mail provider SmtpMail.Send"mymail@gmx.net", "somebody@xxx.ch", "sub",
6
1726
by: toufik | last post by:
Hi, I've a crystal reports Report, Is it possible to send it by email? how? Thanks
10
24368
by: Mike Charney | last post by:
Is there a simple way to send SMTP email from Access VBA? Mike m charney at dunlap hospital dot org
2
5914
by: Rajani | last post by:
Hi friends, I am sending mail from ASP program. My server is win 2k, IIS 5. SMTP server is configured. I am generating a report(purchase order) and the same sending as an email to the supplier. upto last week it was sending well. Now its returning bounce mail. in the c:\inetpub\mailroot\badmail contains the file(.bdr). The contents of
17
7626
by: rdemyan | last post by:
My app creates a building report. My users have requested that I provide functionality to e-mail these "building reports" to building managers once a month. So assuming that I have the following table that lists a building manager's name, e-mail address and their building, is there a way that I can automate this to send these monthly...
0
2339
by: Nanker | last post by:
I would like to integrate Reporting Services reports into an existing email messaging framework using .NET 1.1 (both to leverage the existing framework and since the error reporting by Reporting Services subscriptions isn't that great). Within this C# application, I would like to be able to: - Run a report by hitting a URL, specifying the...
0
2431
by: dreamsoul620 via AccessMonster.com | last post by:
Hi all! I'm trying to set up an email application for my database. I tried linking to my Outlook address book, but when reading from the table, I receive an error message saying I need to restart Access. So I set up a table and a form for users to add email addresses. I have another form (Email_Report) that allows the user to select...
1
9268
by: shil | last post by:
Hi, I'm using FW 2.0 to send an email with an attachment using System.Net.Mail class. If I try to attach a file from my file system, I could successfully send the eamil. But I need to generate a report on the fly and send an email with that report as an attachment. Here is the code I have. ...
1
2821
by: pixie | last post by:
Hi. Access 2003. The database stores contract information. I have a query for each person that is responsible for contracts. The query checks to see if there are reports due either this week, next week, or in three week. A report is created for each query but if the report has no data, it is not saved. I have a button on a form that will run...
0
7912
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7839
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8338
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7959
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8216
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5710
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5390
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3865
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2345
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.