charles
Posts: 59
|
| Posted: 03/10/2007, 8:40 PM |
|
i have developed a leave management system where an email notification is sent to the applicant's HOD with a link to
the approval page in the application.I want to add the departmentID and applicationID parameter to the link so that when the Applicant's HOD clicks on the link in the email notification, the department_id and ApplicationID parameter will be attached to the url link.This values can be captured in the record form submitted.
Here is the code that sends the email to the HOD
Dim Mailer
Set Mailer = Server.CreateObject("Persits.MailSender")
Mailer.From = "salma.mohammed@asosavings.com"
Mailer.FromName = " Message from HCM's Automated Leave Management System"
Mailer.AddAddress leave_apply.deptemail.value
Mailer.Host = "mail.asosavings.com"
Mailer.IsHTML = True
Mailer.subject="A Leave Application requires your attention"
mailer.body="Dear " & leave_apply.deptheadname.value &_
"<p>A New Leave Application was submitted by a staff of your department" &_
"<p><center><FONT COLOR=blue><font size=+2><B>Leave Application Details</CENTER></FONT></font></B>" &_
"<p><b>Application Date</b> " & leave_apply.date_apply.value &_
"<p><b>The Application was submitted by:</b> " & leave_apply.username.value &_
"<p><FONT COLOR=BLUE><b> Leave Type:</FONT></b>" & CCDLookUp("leave_type", "leave_type", "leave_type_id=" &_
DBconnection1.ToSQL(leave_apply.leave_type_id.value, ccsInteger), DBconnection1) &_
"<p><b><font color=blue>leave Start date:</font></b> " & leave_apply.date_from.value &_
"<p><b><font color=blue>leave Resumption Date:</font></b> " & leave_apply.date_back.value &_
"<p><b><font color=blue>No of Days:</font></b> " & leave_apply.days_apply.value &_
"<p><b><font color=blue>Reason:</font></b> " & leave_apply.reason.value &_
" <p> As the HOD of the Applicant,You are required to <b>Approve/Decline</b> This Application." &_
"<p>Please click on the link below to Process:</p>" &_
"<p><a href='http://192.168.4.4/hrms/leave_approveHOD1a.asp'>HOD Approval Page" &_
"<p><b>This Message was automatically Generated by the Leave Management system.</b></p>"
Mailer.Send
set Mailer = Nothing
The Lines
"<p>Please click on the link below to Process:</p>" &_
"<p><a href='http://192.168.4.4/hrms/leave_approveHOD1a.asp'>HOD Approval Page" &_
How can i add the deparrtment_id parameter to the link
Regards,
Charles
|
 |
 |
mhope
Posts: 37
|
| Posted: 03/13/2007, 2:06 PM |
|
Dim DeptID
DeptID = Request.Form(“TheValue department_id”)
You can capture the value how you want and the link as below:
"<p><a href='http://192.168.4.4/hrms/leave_approveHOD1a.asp?department_id=" & DeptID & "'>HOD Approval Page"
|
 |
 |
|