Jump to content

sending email

quailash

By quailash
in ASP

 Share

Recommended Posts

quailash Newbie

quailash

Posted
Posted

Hi, I have an ASP script that displays the names of people who celebrate their b'days on that day. The script works like this: It picks up the names from a database containing the email ids of people & their b'days.NOw the problem is that it only displays "Happy Birthday" with the name of the person. Im not quite sure how to send that page to the particular person's email id.Im unable to attach the scripts for reference. So I have copied & pasted the code below: COuld anyone help me out with this?Script 1:<!--#include file="Includes/dbConn.inc"--><%Dim osRecordSet Set osRecordSet = OraDatabase.DbCreateDynaset("SELECT name, employeeno, leavingdate, to_number(to_char(dob,'mm')) as mm, to_number(to_char(dob,'dd')) as dd FROM tblemployee", cint(0))%><html><head><title>BirthDays   : : Astra Zeneca : :  HR - India</title><meta name="GENERATOR" content="Microsoft FrontPage 3.0"><link rel="stylesheet" href="styles.css" type="text/css"></head><body class="main" topmargin="0" leftmargin="0"><table border="0" cellpadding="0" cellspacing="0" width="100%" height="68"><!--#include file="Includes/header1.html"--> <tr> <td width="100%" colspan="3"></td> </tr> <tr> <td width="15%" height="202" valign="top"><!--#include file="Includes/staticLeft.html"--> </td> <td width="70%" height="202" valign="top" background="Images/birthdaybg.jpg"><table border="0" cellpadding="0" cellspacing="0" width="100%" height="128"> <tr> <td width="100%" valign="top" align="left" height="59" colspan="2"><img src="Images/birthdays.jpg" alt="Birthdays" width="700" height="90"></td> </tr> <tr> <td width="100%" height="21" align="center" colspan="2"><img src="Gifs/!happybd.gif" width="126" height="17" alt="Happy Birthday"></td> </tr> <tr> <td width="50%" height="21" align="center" rowspan="4"><p align="left">  <img src="Gifs/b49.gif" width="291" height="193" alt="Happy Birthday"></td> <td width="50%" height="6" align="center"><img src="Gifs/!hapybd5.gif" width="136" height="18" alt="Happy Birthday" align="right"></td> </tr> <tr> <td width="50%" height="5" align="center"><img src="Gifs/!hapybd0.gif" width="136" height="18" alt="Happy Birthday"></td> </tr> <tr> <td width="50%" height="5" align="center"><img src="Gifs/!hapybd4.gif" width="136" height="18" alt="Happy Birthday" align="left"></td> </tr> <tr> <td width="50%" height="5" align="center"><img src="Gifs/!hapybd2.gif" width="136" height="18" alt="Happy Birthday"></td> </tr> <tr> <td width="100%" height="29" align="center" colspan="2"><!-- Code from here--> <table border="0" width="60%" cellspacing="5"> <tr> <td></td> </tr><!-- Start While Loop--><%Dim cur_dd, cur_mmcur_dd = int(day(date))cur_mm = int(month(date))%><%osRecordSet.MovefirstDim format, fformat = 0While Not osRecordSet.EOFDim dd, mmdd = int(osRecordSet("dd"))mm = int(osRecordSet("mm"))If cur_mm = mm ThenIf cur_dd = dd Thenif osRecordSet("leavingdate") < date() then Response.Write("")elseformat = format + 1 f = format mod 2If f = 0 then%> <tr> <td width="85%"><big><font color="#FF0080"><strong><marquee border="0" behavior="alternate"> <%=osRecordSet("name")%></marquee></strong></font></big></td><%else%> <td width="85%"><big><font color="#FF0080"><strong><marquee border="0" behavior="alternate" direction="right"> <%=osRecordSet("name")%></marquee></strong></font></big></td><%end if%> </tr> <tr> <td><p align="center"><%'=format%><%'=i%><img src="Images/flowers.gif" alt="Flowers" width="350" height="50"></td> </tr><%End ifEnd ifEnd if osRecordSet.MoveNextWend%><!-- End While Loop--> <tr> <td width="100%" height="25"></td> </tr> </table> </td> </tr> </table> </td> <td width="15%" height="202" valign="top" class="right-side"><!-- #include file="Includes/staticRight.html"--> </td> </tr> <tr align="center"><!--#include file="Includes/footer.html"--> </tr></table></body></html>Script 2<!--#include file="Includes/dbConn.inc"--><%Dim osRecordSet Set osRecordSet = OraDatabase.DbCreateDynaset("SELECT name, employeeno, leavingdate, to_number(to_char(dob,'mm')) as mm, to_number(to_char(dob,'dd')) as dd FROM tblemployee WHERE name like '%MANISH%'", cint(0))%><html><head><title>BirthDays   : : Astra Zeneca : :  HR - India</title><meta name="GENERATOR" content="Microsoft FrontPage 3.0"><link rel="stylesheet" href="styles.css" type="text/css"></head><body class="main" topmargin="0" leftmargin="0"><table border="0" cellpadding="0" cellspacing="0" width="100%" height="386"><!--#include file="Includes/header.html"--> <tr> <td width="100%" colspan="3"></td> </tr> <tr> <td width="15%" height="202" valign="top"><!--#include file="Includes/staticLeft.html"--> </td> <td width="70%" height="202" valign="top" background="Images/birthdaybg.jpg"><table border="0" cellpadding="0" cellspacing="0" width="100%" height="128"> <tr> <td width="100%" valign="top" align="left" height="59" colspan="2"><img src="Images/birthdays.jpg" alt="Birthdays" width="700" height="90"></td> </tr> <tr> <td width="100%" height="21" align="center" colspan="2"><img src="Gifs/!happybd.gif" width="126" height="17" alt="Happy Birthday"></td> </tr> <tr> <td width="50%" height="21" align="center" rowspan="4"><p align="left">  <img src="Gifs/b49.gif" width="291" height="193" alt="Happy Birthday"></td> <td width="50%" height="6" align="center"><img src="Gifs/!hapybd5.gif" width="136" height="18" alt="Happy Birthday" align="right"></td> </tr> <tr> <td width="50%" height="5" align="center"><img src="Gifs/!hapybd0.gif" width="136" height="18" alt="Happy Birthday"></td> </tr> <tr> <td width="50%" height="5" align="center"><img src="Gifs/!hapybd4.gif" width="136" height="18" alt="Happy Birthday" align="left"></td> </tr> <tr> <td width="50%" height="5" align="center"><img src="Gifs/!hapybd2.gif" width="136" height="18" alt="Happy Birthday"></td> </tr> <tr> <td width="100%" height="29" align="center" colspan="2"><!-- Code from here--> <table border="0" width="60%" cellspacing="5"> <tr> <td></td> </tr><!-- Start While Loop--><%Dim cur_dd, cur_mmcur_dd = int(day(date))cur_mm = int(month(date))%><%osRecordSet.MovefirstDim format, fformat = 0While Not osRecordSet.EOF%> <tr> <td width="85%"><big><font color="#FF0080"><strong><marquee border="0" behavior="alternate"> <%=osRecordSet("name")%></marquee></strong></font></big></td> <td width="85%"><big><font color="#FF0080"><strong><marquee border="0" behavior="alternate" direction="right"> <%=osRecordSet("name")%></marquee></strong></font></big></td> </tr> <tr> <td><p align="center"><%'=format%><%'=i%><img src="Images/flowers.gif" alt="Flowers" width="350" height="50"></td> </tr><%osRecordSet.MoveNextWend%><!-- End While Loop--> <tr> <td width="100%" height="25"></td> </tr> </table> </td> </tr> </table> </td> <td width="15%" height="202" valign="top" class="right-side"><!-- #include file="Includes/staticRight.html"--> </td> </tr> <tr align="center"><!--#include file="Includes/footer.html"--> </tr></table></body></html>

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...